[Resolved] LIKE / Searching

Rayn

Just to start out, I do not want to use a fulltext search. I do not require one.

I need to know how to make a mysql query that will search a users row I have that searches for the first part of the name. I figured it out for a-z

SELECT * FROM users WHERE username LIKE 'a%'

So using this method or one like how would it get all the users that names start with a 0-9?

Thanks for your time
- Daniel

Rayn

ok I figured it out all on my own.

I just used REGEXP '^[0-9]'

now I need to know how to get all other charecters but 0-9 and a-z?

tomhath

REGEX will do it for you. Something like '^{[^0-9a-zA-Z]} might do it, but there are better ways. Read what the manual says about special characters and character classes:
http://dev.mysql.com/doc/mysql/en/Regexp.html

Rayn

Originally posted by tomhath
REGEX will do it for you. Something like '^{[^0-9a-zA-Z]} might do it, but there are better ways. Read what the manual says about special characters and character classes:
http://dev.mysql.com/doc/mysql/en/Regexp.html

I used

SELECT * FROM users WHERE username NOT REGEXP '^[a-z0-9]'

and it worked