Anthony, I think 5.2.1 Explain Syntax in the manual covers what you are
asking about. PB
- Original Message -
From: Anthony Ward
To: [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 2:26 PM
Subject: good or bad?
Hi,
going to back to the thread of best SQL statment i
Hi,
going to back to the thread of best SQL statment i did:
this
EXPLAIN
SELECT *
FROM `zip`
WHERE longitude
BETWEEN - 98.315 AND - 94.662 AND latitude
BETWEEN 31.696 AND 34.587 AND 3963 * acos( cos( latitude ) * cos( 33.1414 ) + sin(
latitude ) * sin( 33.1414 ) * cos( - 96.5883 - longitude )