sql match pattern regex query

Question

I have regex pattern:

Regex: \d+(\d+:\d+:\d+,\d+ --> \d+:\d+:\d+,\d+)\s+?(.+)?word(.+)?

and I have a table which has subtitle_content column; for example, I have some records like the following example:

1
00:00:10,770 --> 00:00:12,670
CHECK YOUR EMAIL FOR THE SECOND MISSION

2
00:00:14,540 --> 00:00:15,740
READ IT ALONE word

3
00:00:45,940 --> 00:00:47,640
WANTED - SECOND word MISSION

I want to send this regex pattern with my SQL query, my query bring all the content of subtitle,but which query should I use to return only the row of subtitle_content which matches to this regex? in this condition I want to return :

00:00:14,540 --> 00:00:15,740
READ IT ALONE word

00:00:45,940 --> 00:00:47,640
WANTED - SECOND word MISSION

Lovepreet Singh · Accepted Answer · 2016-07-14 09:54:30Z

1

select * from table_name where subtitle_content REGEXP "Regular Expression Here"

answered Jul 14, 2016 at 9:54

Lovepreet Singh

4,8701 gold badge21 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mortada Jafar Over a year ago

thanks , but this query will return all record contain "Regular Expression Here" ... and i want return just rows of record that that contain this "Regular Expression Here"

Collectives™ on Stack Overflow

sql match pattern regex query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related