Have you tried "... WHERE columnname=''; "?? Gurhan
-----Original Message----- From: Andrew Kuebler [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 12:55 PM To: [EMAIL PROTECTED] Subject: Not secting empty strings I want to query records that do not contain empty strings and null values through a SELECT statement. IS NOT NULL works for the nulls, but how I select non-empty strings ("")? I tried everything I can think of and even some non-published statements like name IS NOT '' ..... I just can't figure it out.... Can anyone help me? Thank you in advance! Andrew --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
