//ads: ?> Correct way to use LIKE '%{$var}%' with prepared statements?phpmysqlsqlmysqli PHP Snippet 1:$likeVar = "%" . $yourParam . "%"; $stmt = $mysqli->prepare("SELECT * FROM REGISTRY where name LIKE ?"); $stmt->bind_param("s", $likeVar); $stmt->execute();