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

by

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

To find records beginning with “r” in MySQL with case sensitivity enforced, you would use the following query:

sql
SELECT * FROM your_table WHERE your_column REGEXP BINARY '^r';

This query uses the REGEXP BINARY operator to enforce case sensitivity, and ^r as the regular expression pattern to match any record beginning with “r”.