|
|
Posted by Daz on 10/29/06 00:43
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.
Good thinking, Pedro!
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. :)
Navigation:
[Reply to this message]
|