I want to retrieve names having single quotes. To do this i tryed as select * from hospital where name like' " ' " ' and select * from hospital where name like ''' . But I failed with these two ways . Please help me to do this

 Does this do it for you?  You need escape the single quote and add the wildcarding

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