mike wrote:
>>Try this:
>>
>>SELECT first_name,work_email FROM tb_contacts WHERE
>>tb_contacts.work_email IS NOT NULL;
>>
>>Or if there are also blanks among those e-mail addresses:
>>
>>SELECT first_name,work_email FROM tb_contacts WHERE
>>tb_contacts.work_email IS NOT NULL AND tb_contacts.work_email != '';
>>
>
>
> no difference
Then you probably have email addresses that exist of white space only.
You should probably put a constraint on that if undesirable.
Try using a regular expression like so:
SELECT first_name,work_email
FROM tb_contacts
WHERE work_email !~ '^[[:space:]]*$';
--
Alban Hertroys
MAG Productions
T: +31(0)53 4346874
F: +31(0)53 4346876
E: alban@magproductions.nl
W: http://www.magproductions.nl
