using substring with regex mysql

Asked Jan 11 '17 at 01:02

Active Jan 11 '17 at 01:05

Viewed 1,828 times

I am trying to get year (yyyy) from text/string in the column "title" but for some reason can't get following query to work:

select substring(title,LOCATE(REGEXP '[(][0-9]{4}[)]',title),4) from videos

title column has following values:

abc abc 2001 abc
xyz (2002) xyz

Any assistance will be appreciated.

edited Jan 11 '17 at 01:05

shmosel

asked Jan 11 '17 at 01:02

calmsoul

`REGEXP` can only be used to _match_ patterns, not extract them. You will need to find another way. MySQL may not be the best place to scrub your data. – Tim Biegeleisen Jan 11 '17 at 01:06
@BillKarwin Most of the answers in your link aren't relevant to this question. – shmosel Jan 11 '17 at 01:09
Why is this tagged `tsql`? – shmosel Jan 11 '17 at 01:10
@BillKarwin your duplication is not relevant – calmsoul Jan 11 '17 at 01:41

0 Answers0