Regex Editor & Tester

This PCRE2 regex matches SQL SELECT statements, supporting wildcard (*), comma-separated column lists, qualified table.column names, and function calls like COUNT(*) in the SELECT clause. It captures FROM clauses with multiple tables, optional JOIN...ON conditions, and optional WHERE or LIMIT clauses ending with a semicolon. It also matches standalone SELECT DATABASE(), USER(), or VERSION() queries. Useful for SQL detection, extraction, or validation in log parsing and code analysis.