/* 013 - LIKE (match the string with desired characters)*/ -- create table CREATE TABLE tOne( 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 'Agra' ); -- insert records INSERT INTO tOne(id,name,age,gender,phone,city) VALUES (1,"Ram Kumar","23","M","4022155","Agra"), (2,"Sarita Kumari","21","F","4034421","Delhi"), (3,"Salman Khan","20","M","4056221","Agra"), (4,"Juhi Chawla","28","F","4022156","Bhopal"), (5,"Anil Kapoor","22","M","4025221","Agra"), (6,"John Abraham","21","M","4056776","Delhi"); SELECT * FROM tOne WHERE name LIKE "s%"; -- character start from word s SELECT * FROM tOne WHERE name LIKE "a%"; -- character start from word a SELECT * FROM tOne WHERE name LIKE "ram%"; -- character start from ram SELECT * FROM tOne WHERE name LIKE "rm%"; -- character start form rm SELECT * FROM tOne WHERE name LIKE "%am%"; -- character which has am in between SELECT * FROM tOne WHERE name LIKE "r%" OR name LIKE "s%"; -- character with r or s starting using or operator SELECT * FROM tOne WHERE name NOT LIKE "r%"; SELECT * FROM tOne WHERE BINARY name LIKE "r%"; -- case sensitive SELECT * FROM tOne WHERE name LIKE "%r"; -- value end with chracter r SELECT * FROM tOne WHERE name LIKE "%ar"; -- value end with chracter ar SELECT * FROM tOne WHERE phone LIKE "%21"; -- phone end with 21 SELECT * FROM tOne WHERE name NOT LIKE "%21"; SELECT * FROM tOne WHERE name LIKE "s%n"; -- start form s and end with n SELECT * FROM tOne WHERE name LIKE "r%r"; SELECT * FROM tOne WHERE name LIKE "_am%"; -- only have 1 character at starting, and am at end of that word SELECT * FROM tOne WHERE name LIKE "__m%"; -- only have 2 characters at starting of character m, and no character at end SELECT * FROM tOne WHERE name LIKE "__l%"; SELECT * FROM tOne WHERE name LIKE "r_m%"; -- start with =r, one character in middle, end with =m