The LIKE operator forces MySQL to scan the whole table to find the matching rows therefore it does not allow the database engine to use index for fast searching. As the result, the performance of the query that uses the LIKE operator degrades when you query data from a table that has a large number of rows.