How to write mysql regular expression in where clause?

Question

How do I write a regular expression in where clause to match the following patterns

Pattern 1

~
~ ~
~ ~ ~

Pattern 2

~ ~ |A~b
~ ~ ~|A~b~c
~ ~ ~|this can be anything
~ ~ ~ ~ ~ ~|this can be anything

For pattern 2 just need to match the part before |.

vks · Accepted Answer · 2015-02-26 10:06:23Z

1

^~([ ]+~)*[ ]*(\\|.*|$)

Try this.If you have space before first ~ use

^[ ]*~([ ]+~)*[ ]*(\\|.*|$)

See demo.

answered Feb 26, 2015 at 9:44

vks

68.1k11 gold badges96 silver badges132 bronze badges

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

3 Comments

Thanks for the answer. However, this is also brining ~B~ ~ ~|3~1~2~0~ in the result. There should not be anything between ~'s

Hi, Sometimes I am getting this error when I execute the query. Got error 'empty (sub)expression' from regexp. Any ideas?