MySql like Operator Wildcards

 How to work Select data with Like Operator:

Example:

Like Operator with Wildcards:

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");

LIKE Operator & Wildcards

SELECT * FROM student WHERE name LIKE "s%";

SELECT * FROM student WHERE name LIKE "a%";

SELECT * FROM student WHERE name LIKE "ram%";

SELECT * FROM student WHERE name LIKE "rm%";

SELECT * FROM student WHERE name LIKE "%am%";

SELECT * FROM student WHERE name LIKE "r%" OR name LIKE "s%";

SELECT * FROM student WHERE name NOT LIKE "r%";

SELECT * FROM student WHERE BINARY name LIKE "r%";

SELECT * FROM student WHERE name LIKE "%r";

SELECT * FROM student WHERE name LIKE "%ar";


SELECT * FROM student WHERE phone LIKE "%21";

SELECT * FROM student WHERE name NOT LIKE "%21";

SELECT * FROM student WHERE name LIKE "s%n";

SELECT * FROM student WHERE name LIKE "r%r";

SELECT * FROM student WHERE name LIKE "_am%";

SELECT * FROM student WHERE name LIKE "__m%";

SELECT * FROM student WHERE name LIKE "__l%";

SELECT * FROM student WHERE name LIKE "r_m%";