我尝试在 PDO SELECT 查询中使用 TRIM() 并收到一条语法错误消息“语法错误或访问冲突:1064 你的 SQL 语法有错误;”。我应该怎么做才能纠正这个错误?
D B:
tblrecord (firstname, lastname, score)
PHP:
$firstname = trim('Mary');
$lastname = trim('Lamb');
$sql = "SELECT * FROM tblrecord WHERE TRIM(firstname) AS firstname = ? AND TRIM(lastname) AS lastname = ?";
$stmt = $connection->prepare($sql);
$stmt->execute( array($firstname, $lastname) );
不要在上面使用别名 WHERE
$sql = "SELECT * FROM tblrecord WHERE TRIM(firstname) = ? AND TRIM(lastname) = ?";
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句