MySQL regular expression issue

Question

I have a varchar column "category" with several values:

1.1
1.1.1
2.1
2.2.2
3.1.2.1

Now I want to select all columns with only one "." (dot) in it's value. But "...WHERE category regexp '[.]{1}'..." does not work, even if I escape the "." with a backslash.

Thanks in advance. Matty

Gordon Linoff · Accepted Answer · 2015-01-29 13:18:31Z

3

Just use like:

where category like '%.%' and category not like '%.%.%'

answered Jan 29, 2015 at 13:18

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

MySQL regular expression issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related