Find the Lamps

Easy · Filtering

ILIKE works like LIKE but ignores upper and lower case. Put % on both sides to mean "contains": '%pen%'.

Return the name of every product whose name contains the word lamp in any case (Lamp, LAMP, lamp...).