SQL: select mobile from vte_members mobile regexp '^13[0-9]{9}$|^159[0-9]{8}$' Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'regexp '^13[0-9]{9}$|^159[0-9]{8}$'' at line 1在程序中怎么不能解析到正则表达式呢? 我是这样测试的 $sqlstr=$db->query("select mobile from vte_members mobile regexp '^13[0-9]{9}$|^159[0-9]{8}$'"); while($dbq_rec=$db->fetch_array($sqlstr)) { echo$dbq_rec['mobile']=$dbq_rec['mobile']."<br>"; $mobile_list[]=$dbq_rec; }
select mobile from vte_members where mobile regexp '^13[0-9]{9}$|^159[0-9]{8}$'"; 少了个 where
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'regexp '^13[0-9]{9}$|^159[0-9]{8}$'' at line 1在程序中怎么不能解析到正则表达式呢?
我是这样测试的
$sqlstr=$db->query("select mobile from vte_members mobile regexp '^13[0-9]{9}$|^159[0-9]{8}$'");
while($dbq_rec=$db->fetch_array($sqlstr))
{
echo$dbq_rec['mobile']=$dbq_rec['mobile']."<br>"; $mobile_list[]=$dbq_rec;
}
少了个 where