Comparison Functions – Like And Not Like

/*
  Like
  name => Field Name
*/

SELECT * FROM `try` WHERE name = 'Osama';

SELECT * FROM `try` WHERE name LIKE 'Osama';

SELECT * FROM `try` WHERE name LIKE '%sama'; # % => Empty Or Collection Of Characters

SELECT * FROM `try` WHERE name LIKE '%ama'; # % => Empty Or Collection Of Characters

SELECT * FROM `try` WHERE name LIKE '%ama%';

SELECT * FROM `try` WHERE name LIKE '%i%';

SELECT * FROM `try` WHERE name LIKE 'Z%o';

SELECT * FROM `try` WHERE name LIKE '%a%a%';

SELECT * FROM `try` WHERE name LIKE '_sama'; # _ => One Character

SELECT * FROM `try` WHERE name LIKE 'Sam_h'; # _ => One Character

SELECT * FROM `try` WHERE name LIKE '%m_h';

SELECT * FROM `try` WHERE name LIKE '%_h';

SELECT * FROM `try` WHERE name LIKE '%_%';

/*
  Not Like
  name => Field Name
*/

SELECT * FROM `try` WHERE name NOT LIKE '%sama';