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
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
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
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