SQL查询选择除一个[关闭]之外的所有行

Question

I want to select everything in the table jogos except the row where intCategoria is 11. How can I do that?

$query_GameData = sprintf("SELECT * FROM `jogos` ORDER BY  RAND()");

Answer 1

SELECT *
FROM `jogos`
WHERE intCategoria <> 11
ORDER BY RAND()