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 wrote:
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 error, either, but it returns no records. My guess is that MySQL is interpreting the whole thing literally, rather than looking for what I want.
I need this to return all records where surname begins with the letters A through C (that is, all records with a surname which begins with A, B, or C).
Anybody got a how-to? I'm sure there must be some way, other than to do this three times. Some of these can vary; that is, it may be 0-9, or 0-Z (show all), even, so I don't want to do a bunch of OR'ing, either.
Thanks! --Scott Brown
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]