From: Andrew Kuebler
Date: April 29 2002 4:55pm
Subject: Not secting empty strings
List-Archive: http://lists.mysql.com/mysql/107491
Message-Id: <034401c1ef9e$ac7b0860$1686fea9@ZEUS>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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