how to mysql query where letter begins with

listenmirndt

how would i do a mysql query where the letter begins with (some letter) and filters for case sensitivity?

bradgrafelman

listenmirndt wrote:
the letter begins with (some letter)

Er... that doesn't make any sense. When does a letter "begin with" any letter other than itself? If you're trying to ask how to select rows where a column's value begins with a letter, then you could do something like:

WHERE colName LIKE 'a&#37;'

or:

WHERE LEFT(colName, 1) = 'a'

or:

WHERE colName REGEXP '^a'

(where a is obviously any letter you desire).

listenmirndt wrote:
and filters for case sensitivity?

For that, the easiest thing to do would probably be to use a case-sensitive character collation OR do some CAST'ing in the query to make one of the operands above belong to a case-sensitive character set.

See this page in the MySQL manual for more info: B.5.5.1. Case Sensitivity in String Searches