Regular expression for an SQL query

Question

I'm looking for a regular expression for the below SQL query.

Select * from data where url like '%?%<alphabet>'

Where the

alphabet

can be any alphabet(a-z).

Thanks in advance

Is the regular expression supposed to go into the SQL query? Or do you want a regular expression that finds SQL queries in files? — Asaph, Mar 22 '17 at 18:11
Tag your question with the database you are using. The SQL standard does not require regular expression support so the functionality differs depending on the database. — Gordon Linoff, Mar 22 '17 at 18:13
SQL query is just as an example. We need to use it in string also. — Harikrishnan N, Mar 22 '17 at 18:13

score 4 · Accepted Answer · answered Mar 22 '17 at 18:24

4

While RegEx is not supported in SQL Server you may try using the pattern matching feature of the LIKE keyword.

SELECT * FROM data WHERE url LIKE '%[a-z]'

answered Mar 22 '17 at 18:24

Cyndi Baker

1 Answers1