MySQL REGEXP: Search Based On Regular Expressions: Examples

Back Home

SELECT 
    productname
FROM
    products
WHERE
    productname REGEXP '^(A|B|C)'
ORDER BY productname;

SELECT 
    productname
FROM
    products
WHERE
    productname REGEXP '^a';

SELECT 
    productname
FROM
    products
WHERE
    productname REGEXP BINARY '^C';

SELECT 
    productname
FROM
    products
WHERE
    productname REGEXP 'f$'

SELECT 
    productname
FROM
    products
WHERE
    productname REGEXP 'ford';

SELECT 
    productname
FROM
    products
WHERE
    productname REGEXP '^.{10}$';

SELECT * FROM customers;

SELECT * FROM employees;

SELECT * FROM offices;

SELECT * FROM orderdetails;

SELECT * FROM orders;

SELECT * FROM payments;

SELECT * FROM productlines;

SELECT * FROM products;

Execute

Clear Beautify Minify