REGEXP is a pattern match in which matches pattern anywhere in the search value. Post navigation What is the usage of ENUMs in MySQL? Difference between CHAR and VARCHAR?