Get the MySQL Uptime, version and port details at one query

 mysql> status
--------------
mysql  Ver 14.14 Distrib 5.7.19, for Win64 (x86_64)

Connection id:          9
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.7.19-log MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3307
Uptime:                 38 min 53 sec

Threads: 5  Questions: 300  Slow queries: 0  Opens: 1323  Flush tables: 1  Open
tables: 402  Queries per second avg: 0.128
--------------

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