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]