ibnpaul
04-25-2006, 11:00 PM
Hi all,
One quick question. I want to build a query like this:
SELECT * FROM <table> WHERE <condition>
Where <condition> is a boolean field in the table being accessed. I assumed in the construction of the query that simply placing a boolean-type field in the query after WHERE would cause the MySQL engine to only return the rows where the field is TRUE. Please let me know if this is correct, and will work. Thanks a lot.
One quick question. I want to build a query like this:
SELECT * FROM <table> WHERE <condition>
Where <condition> is a boolean field in the table being accessed. I assumed in the construction of the query that simply placing a boolean-type field in the query after WHERE would cause the MySQL engine to only return the rows where the field is TRUE. Please let me know if this is correct, and will work. Thanks a lot.