----- Original Message ----- From: "Martin Gainty" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 18, 2004 4:24 PM Subject: contains?
> > > is there way to interrogate what is inside a column specifically a special > character? > thanks, > Try the LIKE operator. For example: select * from employee where lastname like 'G%' would show all rows where the employee's last name starts with the letter G (or *is* the letter G by itself, although that would be a very rare case). I'm relatively new to MySQL but it appears that special characters usually get escaped with a backslash so if you're looking for last names that contain an embedded carriage return character anywhere in the field, it appears that you'd need to write: select * from employee where lastname like '%\r%' The representation of various special characters can be found in the "Strings" chapter of the manual at http://dev.mysql.com/doc/mysql/en/String_syntax.html. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
