How and when to use LIKE statement

The LIKE condition allows us to use wildcards in the where clause of an SQL query.

(1)% allows you to match any string of any length (including zero length)

(2)_ allows you to match on a single character