[RESOLVED] SQL query - how too omit record

[rayzun]

SQL query:
SELECT DISTINCT CAT
FROM flor
LIMIT 0 , 30

flor
CAT

today
tonight
today
tonight
tomorrow

My purpose is to not include a record from the field CAT with the value:
[today]

is this possible, with the MySQL query ?

[Sxooter]

add where CAT <>'today'

[rayzun]

oops not working exactly:

$query = "SELECT `CAT` , `NAME` ,  `total`  

FROM `flor` 
WHERE `total` >=0
AND `total` <=999 AND 'CAT' <>'Arrangements'
GROUP BY `CAT` , `NAME` ,  `total`  

ORDER BY `total` DESC 
LIMIT 0 , 1";

[Sxooter]

AND 'CAT' <>'Arrangements'

should be:

AND CAT <>'Arrangements' (or in any other database in the known universe: AND "CAT" <>'Arrangements')

[rayzun]

Right you are, thanks again