Regular expression pattern condition: REGEXP in MySQL
REGEXP is used to match a string against a specified pattern. There are different operators used to match patterns.
1. ^ is used to match beginning of the string.
2. $ is used to match end of the string.
3. * is used to match any character of the string.
4. A* Match any sequence of zero or more A characters.
Example:SELECT 'sample' REGEXP '^s.*$';
Returns 1.
