select * from tabella where campo1 like '%canon%'