-------------- 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 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' > > > > Regards > > > > John B > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > Tiago Serafim > [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
