SELECT productname FROM products WHERE productname REGEXP '^(A|B|C)' ORDER BY productname;
SELECT productname FROM products WHERE productname REGEXP '^a';
SELECT productname FROM products WHERE productname REGEXP BINARY '^C';
SELECT productname FROM products WHERE productname REGEXP 'f$'
SELECT productname FROM products WHERE productname REGEXP 'ford';
SELECT productname FROM products WHERE productname REGEXP '^.{10}$';