[SOLVED] apostrophe in INSERT INTO SQL statement

[dennismonsewicz]

How do you place an apostrophe in a SQL statement?

 

EX:

 

INSERT INTO table (row1, row2) VALUES ('Hello', 'Don't Try');

[.josh]

escape it

 

\'

 

in practical terms (like if you're using vars instead of hardcoding), depending on your situation, you can use addslashes or mysql_real_escape_string

[dennismonsewicz]

I am writing a SQL file and was wondering... i am more used to doing it using PHP to process but i have to write a SQL file for this particular project. Will escaping it your way still work?

[dennismonsewicz]

figured it out.. use two apostrophes instead of one..

 

EX:

 

INSERT INTO table (row1, row2) VALUES ('Hello', 'Don''t Try');

[.josh]

yes, you can escape quotes.

 

INSERT INTO table (row1, row2) VALUES ('Hello', 'Don\'t Try');

 

Or you can use double quotes around the values like so:

 

INSERT INTO table (row1, row2) VALUES ("Hello", "Don't Try");