Regular expression for an SQL query

sql regex ssms-2014
Harikrishnan N picture Harikrishnan N · Mar 22, 2017 · Viewed 9.3k times · Source

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

Answer

Cyndi Baker picture Cyndi Baker · Mar 22, 2017

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

Pattern matching in search conditions

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

Related questions

Java - escape string to prevent SQL injection

I'm trying to put some anti sql injection in place in java and am finding it very difficult to work with the the "replaceAll" string function. Ultimately I need a function that will convert any existing \ to \\, any " to \", any …

Read More
How to regex in a MySQL query

I have a simple task where I need to search a record starting with string characters and a single digit after them. What I'm trying is this SELECT trecord FROM `tbl` WHERE (trecord LIKE 'ALA[d]%') And SELECT trecord …

Read More
Regular expressions inside SQL Server

I have stored values in my database that look like 5XXXXXX, where X can be any digit. In other words, I need to match incoming SQL query strings like 5349878. Does anyone have an idea how to do it? I have …

Read More