> SELECT * FROM listaemail WHERE id LIKE "%%" OR nome LIKE "%%" OR empresa
> LIKE "%%" OR email LIKE "%%" OR ativo LIKE "%%" ORDER BY nome;
>
> Time: 11 Lock_time: 0 Rows_sent: 30567 Rows_examined: 30568
>
> before anyone jumps out and points it out, it is far
> from being optimized. it should (an
to all, warm regards from brazil.
here's the plot: my isp has been complaining
for last couple of days about this query,
generated automatically by a query generator
(no, duh??)...
SELECT * FROM listaemail WHERE id LIKE "%%" OR nome LIKE "%%" OR empresa
LIKE "%%" OR email LIKE "%%" OR ativo LIKE