What is the regex for sql select statement?

The regex pattern for sql select statement is `^\s*SELECT\s+.+\s+FROM\s+\w+`. This pattern validates basic sql select...from statement.

How do I use this regex in JavaScript?

In JavaScript, create the regex with `const regex = /^\s*SELECT\s+.+\s+FROM\s+\w+/;` and test with `regex.test(yourValue)`. It returns `true` if the value matches.

How do I use this regex in Python?

In Python, use `import re; re.match(r'^\s*SELECT\s+.+\s+FROM\s+\w+', value)`. The raw string prefix (`r`) prevents Python from interpreting backslashes as escape characters.

Is this regex case-sensitive?

By default, yes. To make it case-insensitive, add the `i` flag in JavaScript (`/^\s*SELECT\s+.+\s+FROM\s+\w+/i`) or use `re.IGNORECASE` in Python.

Regex for SQL SELECT Statement

Regex Pattern

^\s*SELECT\s+.+\s+FROM\s+\w+

Basic SQL SELECT...FROM statement

Quick Answer

The regex pattern for sql select statement is `^\s*SELECT\s+.+\s+FROM\s+\w+`. Basic SQL SELECT...FROM statement. This works in JavaScript, Python, Ruby, PHP, Java, and most regex engines that support PCRE syntax.

Test Examples

Input	Result
SELECT * FROM users	✓ Matches
SELECT id, name FROM products	✓ Matches
SELECT COUNT(*) FROM orders	✓ Matches
INSERT INTO users	✗ No match
UPDATE users SET	✗ No match
DELETE FROM users	✗ No match

Code Examples

javascript

const regex = /^\s*SELECT\s+.+\s+FROM\s+\w+/;
const isValid = regex.test(value);

python

import re
pattern = r'^\s*SELECT\s+.+\s+FROM\s+\w+'
if re.match(pattern, value):
    print("valid")

ruby

pattern = /^\s*SELECT\s+.+\s+FROM\s+\w+/
if value =~ pattern
  puts "valid"
end

php

if (preg_match('/^\s*SELECT\s+.+\s+FROM\s+\w+/', $value)) {
    echo "valid";
}

java

String pattern = "^\\s*SELECT\\s+.+\\s+FROM\\s+\\w+";
boolean isValid = value.matches(pattern);

Frequently Asked Questions

Related Regex Patterns

JavaScript Variable Name

Valid JavaScript variable/identifier name

Python Variable Name

Valid Python identifier name

CSS Class Name

Valid CSS class name (starts with letter, underscore, or hyphen)

CSS ID Selector

CSS ID selector starting with #

JSON Key

JSON object key (quoted string followed by colon)

Semantic Version (Strict)

Strict semantic versioning (MAJOR.MINOR.PATCH)