select * from tabella where campo like '%pippo%'

Ciao