sql

Change single-quote characters into doubled versions (' becomes '').

Also escapes blackslashes ("\" becomes "\\") unless you put the following somewhere on your page:

• [pragma filter_sql_no_backslash 1]

Also see the "dbi_quote" filter.

Note If you're using the [query] tag then you should use the [PREFIX-quote] sub-tag instead of this filter.

Example

Results in:

Source code