How to retrieve all values starting with a digit

[rashidfarooq]

I want to retrieve all the values from a column (product_name) having its first character a digit. The Data Type of the Column is string. Which SQL Query should I use to achieve my purpose.

For Example I want to retrieve all the values of such like

4your
12Days
44Hours

I hope you will have understand my problem.

[J. H. Rasmussen]

You could use something like this:

"SELECT * FROM thedbtable WHERE product_name REGEXP '^[0-9]'"

[rashidfarooq]

Originally Posted by J. H. Rasmussen

You could use something like this:

"SELECT * FROM thedbtable WHERE product_name REGEXP '^[0-9]'"

Thanks a lot. That query really works fine.

[tanya.dimple]

hi
In Same situation I want to extract values into one column and other text into one column. Can you please help