How to search all string in MySql that start with a number?

Question

I want to run a mysql query to give me all available results that start with a number.

SELECT * FROM users WHERE username LIKE number + '%'

I tried using

LIKE REGEXP '^[0-9]

but it is not working for me

score 3 · Accepted Answer · answered Mar 19 '13 at 23:17

3

You can use REGEXP:

SELECT * 
FROM users 
WHERE username REGEXP '^[0-9]'

answered Mar 19 '13 at 23:17

sgeddes

Just barely faster than me! – rbedger Mar 19 '13 at 23:20
This is the correct answer. It return the string that start with a number – Jaylen Mar 19 '13 at 23:25
@Mike -- Glad we could help! Best of luck. – sgeddes Mar 19 '13 at 23:26

score 2 · Answer 2 · answered Mar 19 '13 at 23:18

2

Your RegExp is wrong, and the way you are using the REGEXP operator is wrong. Your code should be

WHERE username REGEXP '^[0-9].*'

Edit: I'm wrong about the RegEx portion. I didn't realize you don't need the .*

answered Mar 19 '13 at 23:18

rbedger

Thank you for your help but this return any string that contains a number. @sgeddes got it right :) Thanks – Jaylen Mar 19 '13 at 23:26

2 Answers2