[ILUG-Webdev] MySQL selecting against NULL

[Sean O'Donnell]

Just treat null as a special case

Try

select name from test where name not like '%whatever%' or name is NULL;


-----Original Message-----
From: Kae Verens [mailto:kverens at contactjuggling.org] 
Sent: 02 July 2003 10:23
To: webdev at linux.ie
Subject: [ILUG-Webdev] MySQL selecting against NULL

I have a table similar as this:

create table test(
 id int auto_increment not null primary key,
 name text
);

Whenever 'name' is NULL, the following always fails
select name from test where name not like '%whatever%';

any idea of a solution to this?

Kae

-- 
ILUG Web Development
http://mail.linux.ie/mailman/listinfo/webdev/