• try it

    select * from table1 where name like '%''%'