How to select lines only where the first digit is from 0 to 9?

Question

As far as I know, I can do something like:

"SELECT * 
 FROM my_table 
 WHERE my_field LIKE '0%' 
 OR my_field LIKE '1%' 
 OR my_field LIKE '2%' ";

Is there a way to achieve this using regex or something like this:

"SELECT * 
 FROM my_table 
 WHERE my_field LIKE [only first char is 0-9]"??

EDIT: the field is not numeric, and it could be something like "1 People", "211 Pies", etc.

+5

Uuid Mar 15 '13 at 20:52

5 answers

SELECT * FROM table WHERE field REGEXP '^[0-9]'

+2

mavili Mar 15 '13 at 20:59

Select * From my_table Where (REGEXP_LIKE(my_field, '[[:digit:]]%'))

(REGEXP_LIKE(Source_String, '[[:character class:]]')) - , , , . , , .

EDIT: * From my_table (SUBSTR (my_field, 1,1) = '[[: digit:]]') , .

+1

user2175485 15 . '13 20:59

SELECT *
FROM my_table
WHERE left(my_field,1) REGEXP '^[0-9]+';

MSSQL,

SELECT *
FROM my_table
WHERE isNumeric(left(my_field,1)) = 1

0

Matt Busche 15 . '13 20:54

Simple without regular expressions:

SELECT *, SUBSTR(my_field, 1, 1) AS mf FROM my_table HAVING mf BETWEEN '0' AND '9';

Important quotes in the FROM clause!

0

Michael Thessel Mar 15 '13 at 21:27

Jack M. · Accepted Answer · 2013-03-15T20:56:28+0000

try it

SELECT * 
FROM BadlyDesignedTable 
WHERE AnswerColumn RLIKE '^[0-9]+'

I was wondering if a re-expression is possible in where he found it on Google in 30 seconds.