At 1:58 + 7/29/04, [EMAIL PROTECTED] wrote:
-- Original message from Tiago Serafim : --
Hi,
Try the following:
WHERE not (field like '%c%' or field like'%C%')
Cheers,
I think since LIKE is case insensitive, unless the keyword BINARY is present,
Close, but not quite.
> I think since LIKE is case insensitive, unless the keyword BINARY is present, and
> the parser would have to collapse the extraneous parentheses "WHERE NOT LIKE '%c%'"
> would be slightly more efficient.
> applicable manual page --
> http://dev.mysql.com/doc/mysql/en/String_comparison_function
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,
-- Original message from Tiago Serafim : --
> Hi,
>
> Try the following:
>
> WHERE not (field like '%c%' or field like'%C%')
>
> Cheers,
>
I think since LIKE is case insensitive, unless the keyword BINARY is present, and the
parser would have to collapse the ext
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
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 unsubscri
