How can you do that with SQL? One way is to use the LIKE operator ... in the WHERE clause of a SELECT statement to filter rows that match a specified pattern. The LIKE operator allows you to ...

The LIKE operator allows you to use wildcards, such as % and _, to match any sequence or single character in a string. For example, you can use LIKE '%apple%' to find ...