MySql Regex Expression test

Question

I need to check for the digits that are separated by a . or : or /

I tried this :

select 'test text 30.3 " REGEXP '\d+[:./]\d+'

but that returned a 0

I tried it in regex test online and it seems to be working fine and matches the '30.3'. Not sure why it's not working in mysql

this might help: http://stackoverflow.com/questions/28950724/converting-pcre-to-posix-regular-expression — n-dru, Nov 24 '15 at 11:02

score 2 · Accepted Answer · answered Nov 24 '15 at 10:58

2

There's no \d in MySQL, use ranges or :digit: :

SELECT 'test text 30.3' REGEXP '[[:digit:]]+[:./][[:digit:]]+'

answered Nov 24 '15 at 10:58

Maen

1

`[:./]` should be folowed by `{1}` I think, e.g. `SELECT 'test text 30.3' REGEXP '[[:digit:]]+[:./]{1}[[:digit:]]+' `, because it should mark if seperated by `.`, `:`, `/` and not by e.g. `.:` – arnoudhgz Nov 24 '15 at 11:03

1 Answers1