At 1:58 +0000 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. LIKE is case insensitive unless an operand is
a binary string. BINARY happens to cause an operand to be a binary string.
If an operand is already a binary string, LIKE will be case sensitive even
in the absence of BINARY.
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_functions.html
On Wed, 28 Jul 2004 22:23:40 +0100, John Berman
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'
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]