PHP准备语句...将变量绑定为REGEXP中的数字范围? [英] PHP Prepared Statements... Bind variable as numeric range in REGEXP?

问题描述

$query = "SELECT * FROM `mytable` WHERE `file` REGEXP '[:val-9]'";
$stmt = $dbh->prepare($query);
$stmt->bindValue(':val', '1'); //I have also tried 1 without quotes
$stmt->execute();

引发此错误:

语法错误或访问冲突:1139得到错误无效字符" 范围"来自regexp

Syntax error or access violation: 1139 Got error 'invalid character range' from regexp

是否可以这样做.

推荐答案

占位符只能在出现值的地方使用，而不能嵌入字符串中.试试:

Placeholders can only be used where a value can appear, not embedded in strings. Try:

$query = "SELECT * FROM `mytable` WHERE `file` REGEXP CONCAT('[', :val, '-9]')";

这篇关于PHP准备语句...将变量绑定为REGEXP中的数字范围?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！