Hi, List,
I looked here:
http://www.mysql.com/doc/en/String_comparison_functions.html
But I am not seeing what I need.
I want to do a string comparison like this:
SELECT * FROM sometable WHERE surname LIKE '[A-C]%' ORDER BY surname;
This works in another RDBMS. It doesn't return a syntax
This should work for you:
SELECT * FROM sometable WHERE surname BETWEEN 'A' AND 'D' ORDER BY
surname
In my quick test the first parameter is inclusive while the second is
not, which is why it is D and not C.
On Thursday, October 30, 2003, at 02:22 PM, Scott Brown wrote:
I want to do a string
You can use RLIKE which is regular expressions then you should be able to execute
SELECT * FROM sometable WHERE surname RLIKE '^[A-C]' ORDER BY surname;
Kelley
Scott Brown wrote:
Hi, List,
I looked here:
http://www.mysql.com/doc/en/String_comparison_functions.html
But I am not seeing
Thanks for all of the responses!
Actually, Brent Baisley wins the syntax question of the day. The BETWEEN
syntax is what I needed.
REGEXP and RLIKE do not return any records, they return a count of the
number of rows matching the expression.
Thanks!
--Scott Brown
At 11:22 AM 10/30/2003, you
Thanks so much Brent, this is what I was looking for.
However, what do I do when I get to 'Z'?
I looked here, and now I am really confused:
http://www.mysql.com/doc/en/Comparison_Operators.html
It seems to say that BETWEEN returns a rowcount as well?
I am guessing that these all return
Oh, well, chalk it up to experience. RLIKE is what works the way I want. DOH!
Thanks,
--Scott Brown
At 12:34 PM 10/30/2003, you wrote:
Thanks so much Brent, this is what I was looking for.
However, what do I do when I get to 'Z'?
I looked here, and now I am really confused:
The BETWEEN operator works like and greater and less than search.
So, you can do the exact same query like this:
SELECT * FROM sometable WHERE surname='A' AND surname'D'
MySQL may actually optimize them the same way, but using BETWEEN is
more readable.
To include 'Z', just do a greater than
: Need help on WHERE ... LIKE Query
The BETWEEN operator works like and greater and less than search.
So, you can do the exact same query like this:
SELECT * FROM sometable WHERE surname='A' AND surname'D'
MySQL may actually optimize them the same way, but using BETWEEN is
more readable