#1  
Old 31st July 2009, 16:50
bernholdt bernholdt is offline
Senior Member
 
Join Date: Jun 2007
Posts: 156
Thanks: 47
Thanked 13 Times in 11 Posts
 
Default Mysql select

Hi all
hope someone can help me?
I have a select statement need to look something like this

select * from 'client' WEHRE 'row1' >= '1' EXEPT WHERE 'date' = 'value AND 'row1' = 'value2'

What i need it to do is:
I need to show all clients where row 1 = 1 or greater, but i also need to show clients from max 6 month ago where client row = Zero

Any idea ?
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix: "unknown user" with mysql auth. Kruser Server Operation 3 18th June 2009 19:20
ISPconfig 3, dropmail issue Justin Albstmeijer Developers' Forum 10 6th October 2008 22:21
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
Rejected e-mail (unknown user) w/Postfix doronkeller HOWTO-Related Questions 9 27th January 2008 21:09
Multiple MySQL Queries - with Postfix-mysql, courier-authmysql, maildrop-mysql... snowfly HOWTO-Related Questions 4 7th July 2006 05:19


All times are GMT +2. The time now is 16:09.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.