use double quotes in internal quotes... so it dhould be something like: select * from lyric where album like '%Blind Man\''s Zoo%'
I think it'll work. George Christoforakis. ----- Original Message ----- From: "Weston Skeans" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 15, 2003 8:47 PM Subject: Apstrophee Errors > I am using mmysql 3.23.41 and am having querrying problems. I am using my > database to organize music. Whenever I query my database for a album with an > apostrophee in it, It returns no results this is my sintax: > > select * from lyric where album like '%Blind Man\'s Zoo%'; > > I am trying to find songs from 10,000 Maniac's "Blind Man's Zoo" I have > checked the database and all the songs are listed under the album "Blind > Man\'s Zoo". All other queries work fine as long as there aren't any > apostrophees. Any help? > > -Weston > > > -- > 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]
