why does < Greater than, not work but > Does

[lostinsql]

OK, there has to be some trick here in MSQL5. I am trying to do a query using the syntax less than > and greater than <. But for some reason only the less than > works, it does not work when I flip it around to the "greater than" Whats the catch? The query is shown below

SELECT * FROM messages WHERE read = 'no' and sent <2008-07-01

[NogDog]

You probably need to quote the date, otherwise you are comparing sent to 2008 minus 7 minus 1.

[bradgrafelman]

Also, in regards to the thread title... '<' is not "greater than", it's "less than." :p

[lostinsql]

You have done it again SIR Dogman. I know its only simple stuff to Guru's like you but being able to sort out the little things like that make my life a hell of a lot easier. Thanks

[lostinsql]

I always get this mixed up, it just seems more logical to me having the "greater then" shown as <, but thats just me. Time should fix it (I hope) Cheers Bradgrafelman

[NogDog]

lostinsql;10878352 wrote:

I always get this mixed up, it just seems more logical to me having the "greater then" shown as <, but thats just me. Time should fix it (I hope) Cheers Bradgrafelman

Whichever symbol you are using (">" or "<"), just think of it as checking whether the expression on the large (open) side of the symbol is larger than the expression on the small (point) side of the symbol. 🙂