what is "WHERE 1"

[cglaves]

I have installed phpMyAdmin and all queries by default are
'SELECT * FROM `WHATEVER` WHERE 1"

What does the "WHERE 1" portion mean and what is it doing?

I have searched the MYSQL manual and cant find an explanation, if you know where it is please tell.

Thanks

 

[petersJazz]

I have tested and it seems that the "where 1" dont do anything, its the same as not using any where clause.

 

[Guest_imported]

I daresay its "where true" - 1 being the boolean value for true.

To prove/disprove my theory, try "where 0" - "where false" I would assume.

 

[JBrittingham]

Looking at the code. I looks like it is just a default value for a prepared statement. petersJazz is right... It will act as if the where clause does not exist.