USE my_db;
SELECT * FROM student WHERE name LIKE 'John%'; # 1 , starting with John
SELECT * FROM student WHERE name LIKE '%John'; # 2 , ending with John
SELECT * FROM student WHERE name LIKE '%John%'; # 3 , Any where  John is there
SELECT * FROM student WHERE name LIKE 'A%n'; # 4 , Starts with A and ends with n
SELECT * FROM student WHERE name LIKE binary '%no%'; # 5 , Case sensitive search
SELECT * FROM student WHERE mark LIKE '9_'; # 6 , Mark in nineties 
SELECT * FROM student WHERE name LIKE '%alex%' OR name like '%deo%'; # 7 , alex or deo
SELECT * FROM student WHERE name LIKE '%alex%' AND  name like '%John%'; # 8 , alex and  John
SELECT * FROM student WHERE name LIKE '%alex%' OR  name like '%John%'; # 9 , alex OR John
SELECT * FROM student WHERE name LIKE '%ro%' AND  mark LIKE '9_'; # 10 , ro AND  Mark in nineties