Query like operator for "'"

Database
ss
Fan

Query like operator for "'"

Team - Need help for following - 

I need to extract data which include ' in the string, how do I do this with like operator -

 

example - select team_name from table_name where team_name like '%England's Warrior%' 

 

Character ' is not allowing me to execute this.

 

please advice

 

2 REPLIES
Senior Apprentice

Re: Query like operator for "'"

A single quote contained in a string must be doubled:

 '%England''s Warrior%' 

 

 

ss
Fan

Re: Query like operator for "'"

Thank you @dnoeth