I have a simple database with one table "people". Everey "people" got a name and a birthday. I m trying to find a person by his age.
Select * from people where name ='Mike' and birthday < '1962-01-01'
But there s a Mike with birthday 1962-04-02 in my result?! Why? Wham am i doing wrong?
Thanks so much!
Ah i got it:
Select * from people where birthday < '1962-01-01'and name ='Mike'
This works for some reason.. Maybe someone can tell me what s the matter?
This post has been edited by biemel: 08 August 2010 - 02:38 AM