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

Use [[:digit:]] instead of \d.

Wiktor Stribiżew
– Wiktor Stribiżew

2015-11-24 10:55:08 +00:00
Commented Nov 24, 2015 at 10:55 — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Nov 24, 2015 at 10:55
this might help: stackoverflow.com/questions/28950724/…

n-dru
– n-dru

2015-11-24 11:02:35 +00:00
Commented Nov 24, 2015 at 11:02 — n-dru
– n-dru, Commented Nov 24, 2015 at 11:02

Maen · Accepted Answer · 2015-11-24 10:58:59Z

2

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

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

answered Nov 24, 2015 at 10:58

Maen

10.7k3 gold badges47 silver badges71 bronze badges

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

1 Comment

arnoudhgz Over a year ago

[:./] 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. .:

Collectives™ on Stack Overflow

MySql Regex Expression test

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related