error in sql query result while search with nodes

i have one query for search where i have string Ennemie d’état and if i search with key Ennemie d’état then it show data not found problem is in single quote (‘) my query is as below:

WHERE (
post_tbl.title LIKE (‘%${key.replace(/’/g, “”” )}%’) or post_tbl.caption like (‘%${key.replace( /’/g, “”” )}%’) )