Re: Help to improve MySQL query
| From: | Niel Archer | Date: | Sat, 09 Aug 2008 06:32:59 +0000 |
| Subject: | Re: Help to improve MySQL query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45186@lists.php.net to get a copy of this message | ||
Hi
You do not say how you identify the last call (there is no date/time
field for example), so a complete answer is not really possible
Do not use "NOT LIKE 'Completed'", it's an inefficient way of doing
"!=
'Completed'"
--
Niel Archer