Once our database is loaded with large amounts of data, it can be cumbersome to locate data by simply scrolling through the results of SELECT statements. Also, sometimes we don't have the exact or complete text for a column in which we're looking. For these situations, we can use the LIKE operator. With the LIKE operator, we use the percent-sign wildcard twice to indicate that we're searching for all rows in which the title column's data starts with zero or more characters before the pattern of traveler is found, and then zero or more characters may follow.
Re: LIKE Operator
Once our database is loaded with large amounts of data, it can be cumbersome to locate data by simply scrolling through the results of SELECT statements. Also, sometimes we don't have the exact or complete text for a column in which we're looking. For these situations, we can use the LIKE operator. With the LIKE operator, we use the percent-sign wildcard twice to indicate that we're searching for all rows in which the title column's data starts with zero or more characters before the pattern of traveler is found, and then zero or more characters may follow.