SQL & Regex playground

Query a small company database with real SQLite, or test and learn regular expressions with a live matcher and plain-English explainer. Everything runs in your browser.

Guided challenges

Pick a challenge, write your query in the editor below, then press Check. Column names do not matter but column order does; row order only matters when the task asks for sorting.

Query

Ctrl/Cmd + Enter runs the query. Tab indents; press Esc first, then Tab, to move focus out. Several statements are allowed; the last SELECT is shown.

Result

Run a query to see results here.

History

SQL cheat sheet

Pattern and test text

Pattern

Flags

g global · i ignore case · m multiline · s dotAll · u unicode · y sticky. Hover or focus a flag for details.

Test string

Matches

Matches alternate between a solid underline and a dashed underline. A red bar marks an empty match.

Replace

Replacement (use $1, $<name>, $&)

Result

Plain-English explainer

Hover or focus a row to highlight that part of the pattern.

Common patterns

Regex challenges

Write one pattern that matches every string in the first list and none in the second. Each challenge says whether the whole string must match or the pattern may match anywhere.

Regex cheat sheet