Any queay like "like %sth%" in Mysql?

What have you tried and where did you get stuck? While you can do a wildcard search, this is probably not what you want. Maybe look into both tokenization and ngrams to see what you need to solve your problem.