(I just discovered cracked.com) #10. Searching for a NULL SELECT * FROM a WHERE a.column = NULL In SQL, a NULL is never equal to anything, even another NULL. This query won't return anything and in fact will be thrown out by the optimizer when building the plan. When searching for NULL values, use this instead: SELECT * FROM a WHERE a.column IS NULL #9. LEFT JOIN with additional conditions SELECT
![10 things in MySQL (that won't work as expected).](https://cdn-ak-scissors.b.st-hatena.com/image/square/55a307e24d88888a111efd338b6671f14fd8bc36/height=288;version=1;width=512/https%3A%2F%2Fexplainextended.com%2Fwp-content%2Fuploads%2F2010%2F11%2FMG_2538-e1288838824800.jpg)