Posted by Pedro Graca on 10/29/06 03:17

Daz wrote:
> Pedro Graca wrote:
>> 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.
>
> Many thanks for your suggestion, I will give it a go. I can never quite
> understand what the results of EXPLAIN means, but I guess I'd better
> start learning. :)

If there is no difference between the explains you can postpone studying
the EXPLAIN results LOL

--
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*.

• Next in forum: Re: what is the header to stop buffering?
• Prev in forum: Re: Problem with executing MySQL queries through PHP.
• Thread view: Re: Problem with executing MySQL queries through PHP.

[Reply to this message]