To match values containing a text like 'a' in the beginning, end or middle, we use two wildcards, like '%a%'.
'a'
'%a%'
Make sure to type '%a%'.