AutoFilter for a Text in a Long String:

You can use the Custom option to filter for cells that contain specific text. However, if the text is located after the 255th character in the cell, it won't be found. Also, the long text strings don't appear in the dropdown list in the heading cell.
As a workaround, enter the search text string in a cell on the worksheet. Then add a formula to check for the text.
1. Insert a new column in the database, and in the heading cell, type the word you're searching for, e.g.: Shop
2. Enter the following formula in row 2 of the new column:
=ISNUMBER(SEARCH($B$1,A2))
3. Copy the formula down to the last row
4. Filter column B for TRUE
5. To filter for a different word, type a new string in cell B1, and reapply the filter in column B.
Note: SEARCH is not case sensitive. For a case sensitive filter, use FIND, e.g.: