SQL LIKE is not working when string contains single quote '
,
Below is my php code
$keysearch = "St.Joseph's"; // Searching keyword containing single quotes
$sql =mysqli_query("select id,name from tbl where name LIKE '%$keysearch%'");
It returns no result,
How can I search a string contain single quotes?
Is there any effective operator except 'LIKE' for comparing single quotes value in DB?