using quotes in sql query

[Anon]

i'm trying to perform a query using quotes in sql, but obviously this won't work. how do i get sql to see quote as character and not the terminator.

query:
select * from mytable
where row = 'robert's table';

               ^ how can i have the quote work?

[saltwater]

use \' instead

[saltwater]

so your query becomes:
$query="select * from mytable where row = 'robert\'s table'";

[Anon]

In MySQL - 'robert\'s table'
In Oracle/MSSQL/others 'robert''s table'