Getting empty result using Regular Expression function in MySQL

Question

I am using the following query

SELECT * FROM xnwu4_shows WHERE show_name REGEXP '^(0-9)'

it gives a empty result but according to mysql mannual used function is correct and should be gives some result because my database table have type (Regular Expression, string started with a numeric value or any number) of data.

Give me any idea to resolve above problem

Please return to some of your earlier questions and mark answers accepted where appropriate and correct. You are more likely to get more and swifter help here in the future if you do. — Michael Berkowski
– Michael Berkowski, Commented Jan 13, 2012 at 16:09

Michael Berkowski · Accepted Answer · 2012-01-13 16:03:13Z

3

I think you want [] instead of ()

SELECT * FROM xnwu4_shows WHERE show_name REGEXP '^[0-9]'

This assumes you are attempting to match a digit 0-9 at the beginning of the string, rather than the literal string '0-9', which is what is being matched by (0-9) in parentheses.

answered Jan 13, 2012 at 16:03

Michael Berkowski

271k47 gold badges452 silver badges395 bronze badges

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

Collectives™ on Stack Overflow

Getting empty result using Regular Expression function in MySQL

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