Olav Mørkrid wrote:
hello
does anyone know what is returned when you do a where column without
further parameters?
SELECT * FROM TABLE WHERE COLUMN;
for integer columns it seems to return non-zero columns, but for other
types of columns the results seemed unpredictable.
The value of the column will be converted to a TRUE or FALSE value (1 or
0). If the column would evaluate in a numerical setting to a value of 0,
the statement would read "WHERE FALSE" and not show that row. Can you
provide an example of a resultset that does not make sense to you?
Its no different than providing an actual equation to provide the true
or false condition
SELECT... FROM ... WHERE 0 will always return no data as the WHERE
condition will never be true.
--
Shawn Green, Support Engineer
MySQL Inc., USA, www.mysql.com
Office: Blountville, TN
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /
/ /|_/ / // /\ \/ /_/ / /__
/_/ /_/\_, /___/\___\_\___/
<___/
Join the Quality Contribution Program Today!
http://dev.mysql.com/qualitycontribution.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
