Great! Because the % sign fills in for any characters before and after 'in', the LIKE operator looks for records that contain 'in'.
%
'in'
LIKE
Psst: these substitutes for other characters are also known as wildcards.
That's not really a pattern, is it?