prova così...
SELECT date_format(data,'%d/%m/%Y') FROM tabella WHERE.....
http://dev.mysql.com/doc/refman/5.0/...functions.html

Ciao