command line escape for apostrophe

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

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
To: MySQL List Subject: 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