Use a regular expression to find records. Use "REGEXP BINARY" to force case-sensitivity. This finds any record beginning with r. | Eklavya Online

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

mysql> SELECT * FROM tablename WHERE rec RLIKE “^r”;