Are you not able to do SELECT * FROM table WHERE col = "O\'Brien" ?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/25/04, 1:25:06 PM, Larry Brown <[EMAIL PROTECTED]> wrote regarding command line escape for apostrophe: > I usually use php for most of my work, but I have to run a fair percentage > of maintenance etc from the mysql shell program. I have a record that has > an apostrophe and so was inserted using php by escaping the ' with \ so that > it was put in as \' and it shows up in the record as O'Brien as it should. > I am trying to run a select statement from the shell program and it will not > accept \ or double '' for escaping it. Pretty simple problem, but I can't > find anything via google for it. (Or the manual for that matter. ) > TIA > Larry > -- > 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]
