I saw a select statement with something like this in the where part 'LIKE %Blabla%Another%', now I tried it myself and I don't clearly understand how it works. The thing I'm confused about is the % in the middle, I understand how '%Blabla Another%' works, but with the % as a replacement for the space, I got confused.
% means "any sequence of characters, including an empty one". So
LIKE '%Blabla%Another%' will match, for example
' Blabla Another '