where like % in mysql code example

Example 1: like operator in sql

(Like) Operator for partial searches using wildcard '%' and '_'
For Example:
Select * From Employees
Where last_name LIKE '_a%';

Example 2: like sql

syntax => SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern 
////example/////
///The "%" sign can be used to define wildcards (missing letters in the pattern) both before and after
the pattern.
SELECT * FROM Persons
WHERE City LIKE 's%'