SQL Escape
Escape text for SQL string literals — doubles single quotes, optional full literal output.
Runs locally in your browser. Your input is not uploaded.
How to Use
- 1
Paste the text
Any text containing quotes or special characters.
- 2
Choose the style
Standard SQL ('') or MySQL backslash escaping.
- 3
Copy the literal
With wrapping enabled the output drops straight into a query.
Frequently Asked Questions
- Standard SQL doubles the single quote: O'Brien becomes 'O''Brien'. MySQL also accepts backslash escaping (\'), which the MySQL style option produces along with \n for newlines.
Related Tools
CSS FormatterMinify or beautify CSS stylesheetsJS FormatterMinify or beautify JavaScript codeHTML FormatterBeautify or minify HTML markupHTML EscapeEscape special HTML characters to entitiesHTML StripperRemove all HTML tags to extract plain textHTML EntitiesSearchable reference for all HTML entity codesSQL FormatterBeautify and format SQL queriesXML FormatterFormat, validate, and minify XML documents instantly