我不能将SQL LIKE
与变量一起使用
$sql = "SELECT * FROM chat WHERE name LIKE 'Motherboard' "; //This works
但如果使用变量,它就不起作用:
$sql = "SELECT * FROM chat WHERE name LIKE '%'+$variable+'%' ";
//or
$sql = "SELECT * FROM chat WHERE name LIKE '$variable' ";
我该怎么修?
在PHP中,用一个点连接字符串。
$sql = "SELECT * FROM chat WHERE name LIKE '" . $variable . "' ";
您还可以使用双引号中的变量:
$sql = "SELECT * FROM chat WHERE name LIKE '$variable' ";
或
$sql = "SELECT * FROM chat WHERE name LIKE '{$variable}' ";
请记住,双引号的工作速度比单引号慢。在你的情况下,它将是
$sql = "SELECT * FROM chat WHERE name LIKE '%{$variable}%' ";