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