MySql pattern matching

Question

I need a MySQL pattern to match a number, followed by a question mark. I need something like ... like '%[0-9]?%' but I have no idea how to create this regular expression.

http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html does not help.

Thanks!

I have a column of type text. I have to find some records in it. I have tried SELECT * FROM table WHERE column like '%[0-9]?%'; SELECT * FROM table WHERE column like '%^[0-9]?$%' and so on... — Дамян Станчев
– Дамян Станчев, Commented Apr 1, 2012 at 15:26

Robbie · Accepted Answer · 2012-04-01 15:31:26Z

4

you could try this:

SELECT * FROM YourTable WHERE YourField REGEXP '[0-9]\\?'

That will return rows where YourField contains a number followed by a ? anywhere in the value.

If you want it to only match if the whole field is a number followed by a ?. I.e. 9? then you could use this regex instead:

^[0-9]\\?$

edited Apr 1, 2012 at 15:31

answered Apr 1, 2012 at 15:25

Robbie

19.6k4 gold badges44 silver badges45 bronze badges

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

2 Comments

Дамян Станчев Over a year ago

This does not escape the ?-sign

Robbie Over a year ago

@ДамянСтанчев your right, i totally forgot about escaping, i've corrected it.

Mosty Mostacho · Accepted Answer · 2012-04-01 15:28:10Z

1

I guess you're looking for something like this:

select * from table
where field rlike '[0-9]\\?'

Remember to escape the question mark. Otherwise, it will make the number optional.

Source.

answered Apr 1, 2012 at 15:28

Mosty Mostacho

43.6k16 gold badges99 silver badges124 bronze badges

1 Comment

Дамян Станчев Over a year ago

Thank you. This works just fine. I'll also take a look at the rlike syntax.

Collectives™ on Stack Overflow

MySql pattern matching

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related