MySQL question (AND 1)

[wuno]

There is query that I can't really understand.

SELECT id, rank FROM categories WHERE rank > 29 AND 1 ORDER BY rank LIMIT 1

What does AND 1 really mean?

Thanks in advance.

Norman

[tsinka]

Hi,

I think you can remove the AND 1 part.

SELECT * FROM table WHERE 1

returns just every record because 1 is always true.

Your query returns every record where rank>29.
AND 1 does nothing in this case.
If you change AND 1 to AND 0 you'll get no records.

The AND 1 part could make sense if the query is built dynamically by your script. How does the script look like ?

Thomas