What's the use of 'WHERE TRUE' ?

[terryds]

Hi, guys... Can you tell me what's the difference between

SELECT column FROM table WHERE TRUE

and

SELECT column FROM table

And

SELECT column FROM table WHERE 1=1

Thanks for any answers

Edited June 7, 2013 by terryds

[justsomeguy]

There's no functional difference.

[terryds]

So, What's the importance of using 'WHERE TRUE' ? I see some php-sqlprogrammers use this...

[justsomeguy]

The only reason I'll do something like that is if I have a list of possible where conditions that I may add to the query, and want to make sure there is at least one condition so that everything else can have AND before it. Using those conditions has no other effect on a query, they just tell it to return all rows.