tags:

views:

103

answers:

1

In postgresql, it's possible to use "Dollar-Quoted String Constants" to avoid escaping single quotes in constant strings:

Without Dollar-Quoted String Constants:

'Jeff''s table'

With Dollar-Quoted String Constants:

$$Jeff's table$$

Is there a MySQL equivalent?

On edit: I'm not looking for a way to sanitize inputs, I'm looking for a way to make queries that generate sql easier to read.

+2  A: 
Joel Coehoorn