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