[Mysql & PHP] Query e clausola where

[minos88]

prova con...

SELECT * FROM nome_tabella WHERE SUBSTR(data_ins, 5, 2) = '14' ORDER BY ID DESC;

[chef]

prova con...

SELECT * FROM nome_tabella WHERE SUBSTR(data_ins, 5, 2) = '14' ORDER BY ID DESC;

Ho provato subito... ma mi esce questo errore:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /web/...


Ho provato anche:
SELECT * FROM nome_tabella WHERE SUBSTR(data_ins, 5, 2) = '14' ORDER BY ID DESC;
SELECT * FROM nome_tabella WHERE SUBSTR(data_ins, 5, 2) = 14 ORDER BY ID DESC;

ma niente...