WHERE 1

    Date: 03/27/08 (MySQL Communtiy)    Keywords: no keywords

    Hi all. Can anyone please tell me what the difference is between these two selects?


    SELECT * FROM `table`

    and

    SELECT * FROM `table` WHERE 1

    Source: http://community.livejournal.com/mysql/126599.html

« Designing a large database || Memory leak? »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home