Posted by Pedro Graca on 10/28/06 22:17

Daz wrote:
> Oh, and this is th query that takes more than 5 seconds when executed
> through PHP:
> SELECT book_id AS bid, LEFT(book_name,1) AS letter,
> IF(is_retired='1',1,0) AS retired FROM pp_books;

Probably a wild-goose chase ... but try

explain
SELECT book_id AS bid, LEFT(book_name,1) AS letter,
IF(is_retired='1',1,0) AS retired FROM pp_books;

both in PHP and in the CLI. See if there's any difference.

--
I (almost) never check the dodgeit address.
If you *really* need to mail me, use the address in the Reply-To
header with a message in *plain* *text* *without* *attachments*.

[Back to original message]