How do I select by a range of starting characters?

问题:

Here is my mySQL query:

SELECT *
FROM `eodList` 
WHERE datechanged>='$curdate' 
GROUP BY symbolName 
ORDER BY dateChanged DESC

How do I get all rows (for example) where symbolName starts with letters A-F?

---

Update:

I need something that can be easily changed to another range without alot of code changes.

回答1:

Try with Regex

WHERE symbolName REGEXP '^[A-F]'

回答2:

Faster than Regular expressions and SUBSTRING() function calls. This will use the index of symbolName :

WHERE symbolName >= 'A' 
  AND symbolName < 'G'

There is an issue with the case sensitivity though. Do you want names which start with a..f too or not?

If you want only names that start with uppercase and the table has utf8 character set, use:

WHERE symbolName >= 'A' COLLATE utf8_bin
  AND symbolName < 'G' COLLATE utf8_bin

For other character sets, use the corresponding _bin collation.

回答3:

SELECT *
FROM `eodList` 
WHERE datechanged>='$curdate' AND


((SUBSTRING(symbolName, 1, 1) >= "A" AND SUBSTRING(symbolName, 1, 1) <="F"))
GROUP BY symbolName 
ORDER BY dateChanged DESC