Mysql 8 (REGEXP_LIKE) Examples

SELECT * FROM pet WHERE REGEXP_LIKE(name, '^b'); //SELECT the name start with b

 SELECT * FROM pet WHERE REGEXP_LIKE(name, 'boy'); //SELECT the name which contains boy

 SELECT * FROM pet WHERE REGEXP_LIKE(name, '^.....$');// select only 5 character length name

 SELECT * FROM pet WHERE REGEXP_LIKE(name, '^.{5}$');// select only 5 character length name

 SELECT * FROM pet WHERE REGEXP_LIKE(name, '^[m-q]');//select records with name start with m to q

 SELECT * FROM pet WHERE REGEXP_LIKE(name, '^[m-q]','c');//select records with name start with m to q (case sensitive)

 SELECT * FROM pet WHERE REGEXP_LIKE(name, '^[m-q]','i');//select records with name start with m to q (insensitive)

 SELECT * FROM pet WHERE REGEXP_LIKE(name, 'ri|om');//select records with name contains ri or om

 SELECT * FROM pet WHERE REGEXP_LIKE('fo\no', '^fo\no$');//start & end with fo\no

Some more Exercise 

 SELECT * FROM pet WHERE REGEXP_LIKE('Ban', '^Ba*n');                     -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('Baaan', '^Ba*n');                  -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('Bn', '^Ba*n');                       -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('Ban', '^Ba+n');                     -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('Bn', '^Ba+n');                       -> 0
 SELECT * FROM pet WHERE REGEXP_LIKE('Bn', '^Ba?n');                       -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('Ban', '^Ba?n');                     -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('Baan', '^Ba?n');                    -> 0
 SELECT * FROM pet WHERE REGEXP_LIKE('pi', 'pi|apa');                          -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('axe', 'pi|apa');                        -> 0
 SELECT * FROM pet WHERE REGEXP_LIKE('apa', 'pi|apa');                        -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('apa', '^(pi|apa)$');                  -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('pi', '^(pi|apa)$');                     -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('pix', '^(pi|apa)$');                   -> 0
 SELECT * FROM pet WHERE REGEXP_LIKE('abcde', 'a[bcd]{2}e');             -> 0
 SELECT * FROM pet WHERE REGEXP_LIKE('abcde', 'a[bcd]{3}e');             -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('abcde', 'a[bcd]{1,10}e');        -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('aXbc', '[a-dXYZ]');                -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('aXbc', '^[a-dXYZ]$');            -> 0
 SELECT * FROM pet WHERE REGEXP_LIKE('aXbc', '^[a-dXYZ]+$');          -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('aXbc', '^[^a-dXYZ]+$');        -> 0
 SELECT * FROM pet WHERE REGEXP_LIKE('gheis', '^[^a-dXYZ]+$');        -> 1
 SELECT * FROM pet WHERE REGEXP_LIKE('gheisa', '^[^a-dXYZ]+$');       -> 0