sql语法急求
select `id`,`linkurl` from `users` where `id` not in('143,137,137,153,88,3') and `able`='yes' order by `jifen` desc limit 1这样写法对吗
怎么把变量
$value=143,137,137,153,88,3';传入到
select `id`,`linkurl` from `users` where `id` not in('$value') and `able`='yes' order by `jifen` desc limit 1
------解决方案--------------------
若 id 是字符型的或一定要加单引号的话，$value 需加工一下
$value = '143,137,137,153,88,3';
$value = str_replace(',', ',', $value);
... `id` not in('{$value}') ...