What is regex in MySQL?
Regex is an operational and powerful pattern that can help the users for the implementation of a powerful search utility function for database systems. Moreover, it is an operator which is used when we require matching regular expressions. In addition to this, it also supports a wider range of meta-characters which allow flexibility and more control over the database structure when performing pattern matching.
Match beginning of string(^):
SELECT name FROM users WHERE name REGEXP '^bestinterviewquestion';