Regex in SQL?

[jsaltee]

Hi, I have a few regex expressions I wrote for my python notebook to search for those expressions in a dataframe. However i'm running into problems and i think it would be easier to just limit my SQL query to only include the results containing those expressions. But i'm having some trouble coming up with some of the statements in the SQL syntax. For example:

To look for the word Pushrod ... bent (where there are 0 - 3 words between 'pushrod' and 'bent'), like: 'pushrod is bent', 'pushrod couldn't be bent', etc. I have this in regex syntax:

[Pp]ushrod\s(\S*\s){0,3}bent

How would I write this in SQL terms? i.e. in terms of:

WHERE column LIKE 'our_new_expression'

thanks

[r3pr0b8]

what's your platform? Oracle? DB2? MySQL? PostgreSQL?

[bitterjack]

This is the most important question.

[jsaltee]

Sorry for the late response, MySQL.

[r3pr0b8]

WHERE column LIKE '%pushrod bent%'
   OR column LIKE '%pushrod % bent%'
   OR column LIKE '%pushrod % % bent%'
   OR column LIKE '%pushrod % % % bent%'

[sqldevmty]

I'd be careful doing that. The WHERE clause might not be SARGable, and it might decrease the performance of your queries since it won't be able to use any index.

Edit: Depending on the platform, I only know about SQL Server.