If you want all values why not just do SELECT * FROM testdb ... The `%` will not match NULL values.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 3/3/04, 9:41:22 AM, "Jonas Lindén" <[EMAIL PROTECTED]> wrote regarding LIKE % not including NULL values?: > Hello list > SELECT * FROM testdb WHERE col1 LIKE '%' > The above SELECT statement doesnt return columns with NULL values. > Should it? ;). Should I approce the problem in another direction? > Regards > /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
