Find a word by part of a word?

Question

SQL

How to find a word by half a word? For example: input(Micro), output(Microsoft)

Answer 1

Select * from mytable where mt_text LIKE query + '%'

Answer 2

Try ... field like '%part of word%'