SELECT COUNT(*)
Posted: Sun Oct 08, 2006 1:29 pm
Is a query like this:
faster than a query like this?
If so why? Wouldn't it still have to look through the same amount of records? Thanks.
Code: Select all
SELECT COUNT( * ) AS count
FROM `table`
WHERE `email` LIKE 'Ploo%';Code: Select all
SELECT *
FROM `table`
WHERE `email` LIKE 'Ploo%'