LIKE requires wildcard characters, in the same what the Windows File names can:
"*.jpg" for example returns all files ending with ".jpg"
For SQL the wild card is '%':
SELECT * FROM MyTable WHERE UserName LIKE '%fred%'
will return:
fred
alfred
freda
hello, my name is fred the dwarf warrior