MySql Regular Expression

 How to work Regular Expression:

Example:

Regular Expression Pattern with Description:

Syntax:

Code:
CREATE TABLE student( id INT NOT NULL UNIQUE, name VARCHAR(50) NOT NULL, age INT NOT NULL CHECK(age >= 18), gender VARCHAR(1) NOT NULL, phone VARCHAR(10) NOT NULL UNIQUE, city VARCHAR(15) NOT NULL DEFAULT 'MUL' );

Insert Records

INSERT INTO student(id,name,age,gender,phone,city)
VALUES
(1,"Asif","13","M","4022155","BHW"),
(2,"Saqib","21","M","4034421","Mul"),
(3,"Salman Khan","20","M","4056221","Mul"),
(4,"Maryam","18","F","4022155","DG Khan"),
(5,"Hamza","22","M","4025221","Mul"),
(6,"Anela","21","F","4056776","LHR");

Regular Expression

SELECT * FROM personal WHERE name REGEXP 'ra';

SELECT * FROM personal WHERE name REGEXP 'ta';

SELECT * FROM personal WHERE name REGEXP 'man';

SELECT * FROM personal WHERE name REGEXP '^ra';

SELECT * FROM personal WHERE name REGEXP '^sa';

SELECT * FROM personal WHERE name REGEXP 'an$';

SELECT * FROM personal WHERE name REGEXP 'ram|kapoor|khan';

SELECT * FROM personal WHERE name REGEXP 'ram|poor|khan';

SELECT * FROM personal WHERE name REGEXP '^ram|poor|^khan';

SELECT * FROM personal WHERE name REGEXP '^ram|poor|khan$';

SELECT * FROM personal WHERE name REGEXP '[is]';

SELECT * FROM personal WHERE name REGEXP '[rm]';

SELECT * FROM personal WHERE name REGEXP '[rm]a';

SELECT * FROM personal WHERE name REGEXP '[rmh]a';

SELECT * FROM personal WHERE name REGEXP '^[rs]';

SELECT * FROM personal WHERE name REGEXP '[rs]$';

SELECT * FROM personal WHERE name REGEXP '[ra]$';

SELECT * FROM personal WHERE name REGEXP 'r[am]';

SELECT * FROM personal WHERE name REGEXP '[a-j]r';