The LIKE statement is used for searching records with partial strings in MySQL. By default the query with LIKE matches case-insensitive recores . Means query will match both records in lowercase or uppercase. For example, Search all records un colors table where name is start with “Gr”.