🔤 SQL Escape / Unescape

Escapes or unescapes a SQL string removing traces of offending characters that could prevent execution.

Developer's Tool

SQL Escape Rules

The following rules are applied:

Escapes all single quote characters by doubling them.
Ex: select * from table where value = 'a single quote' is offensive';

becomes:

select * from table where value = 'a single quote'' is offensive';

Copy-paste the SQL to escape or unescape here

SELECT * FROM users WHERE username = 'O'Reilly' AND password = 'pass'

Result

Escape character for LIKE None (default) Backslash (\) Exclamation (!)

Identifier quoting None Backtick (`) - MySQL Double quote (") - ANSI SQL Brackets ([]) - SQL Server