1.

What is regex in MySQL?

Answer»

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.

Example

Match BEGINNING of string(^):

SELECT name FROM users WHERE name REGEXP '^bestinterviewquestion';


Discussion

No Comment Found

Related InterviewSolutions