Real quick MySQL question....

[DAM]

I want to be able to extract only the names that fits some range ie <A-C> <D-F> <etc>

I am trying to do:

SELECT * FROM user WHERE name LIKE "a%" or "c%";


but that doesn't work, any tips welcomed.



thanks.
dam()

Yes i know wrong forum, yes i know I already googled the problem.

 

[bunker]

Look at BETWEEN

 

[ggavinmoss]

SELECT * FROM user WHERE substring(name, 1, 1) >= 'a' AND substring(name, 1, 1) <= 'c'

-geoff

 

[DAM]

I think I love you.


Thanks!!!

 

[DAM]

Thanks for the expression gg, but i went with the between statement:


SELECT * FROM user WHERE name BETWEEN "a%" AND "dz%"


dam()

 

[ndee]

w3schools.com is a pretty neat site for such quick questions.

 

[bunker]

Originally posted by: DAM
I think I love you.


Thanks!!!

Your welcome, but I think I'm going to reject your love .
I'm already married and I don't think my wife would appreciate some random guy from the internet loving me .