Hello,
It should ---- select * from table where field not like '%c%';
or to be safe;
select * from table where field not like 'c%' and field not like '%c' and field not like '%c%';
Fred.
Tiago Serafim wrote:
Hi,
Try the following:
WHERE not (field like '%c%' or field like'%C%')
Cheers,
On Wed, 28 Jul 2004 22:23:40 +0100, John Berman
<[EMAIL PROTECTED]> wrote:
Hi
Sure this is easy
Im trying to create a simple select query but I want to return records unless a field contains a C or c so would it be something like
where field <> 'c' or 'C'
Regards
John B
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
