如何查询选择除id等于1和2的所有用户 ?
SELECT *
FROM $viewUsuarios
WHERE login LIKE '%$busca%'
OR nome LIKE '%$busca%'
OR sobrenome LIKE '%$busca%'
OR senhasErradas LIKE '%$busca%'
OR ADMIN LIKE '%$busca%'
OR ativo LIKE '%$busca%'
OR verificado LIKE '%$busca%'
OR termoUso LIKE '%$busca%'
OR versaoTermoUso LIKE '%$busca%'
ORDER BY id ASC LIMIT $contadornInicioRegistros,
$limiteRegistros
这个查询应该可以工作。
SELECT * FROM users WHERE id NOT IN (1, 2)
我相信一个简单的!=操作符就足够了。
交货。"SELECT * from {$viewUsarios} WHERE id != 1 AND id != 2";
来源:http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html
您将添加AND你的查询应该是这样的。
SELECT * FROM $viewUsuarios
WHERE login LIKE '%$busca%' OR
nome LIKE '%$busca%' OR
sobrenome LIKE '%$busca%' OR
senhasErradas LIKE '%$busca%' OR
admin LIKE '%$busca%' OR
ativo LIKE '%$busca%' OR
verificado LIKE '%$busca%' OR
termoUso LIKE '%$busca%' OR
versaoTermoUso LIKE '%$busca%' AND
id>2
ORDER BY id ASC
LIMIT $contadornInicioRegistros, $limiteRegistros
我希望它能帮助…div;)