Re: command line escape for apostrophe

2004-02-25 Thread Paul DuBois
At 14:25 -0500 2/25/04, Larry Brown wrote: 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

Re: command line escape for apostrophe

2004-02-25 Thread vpendleton
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

RE: command line escape for apostrophe

2004-02-25 Thread Larry Brown
My bad people. The error was elsewhere in the query, but the error happenned to describe the query as failing near where the apostrophe was. Sorry to waste anyone's time. Larry -Original Message- From: Larry Brown [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 2:25 PM To: