 | | | enum query results strange. | enum query results strange. 2006-07-04 - By John Hicks
Back
Tanner Postert wrote:
> so i am doing a query on an enum field:
> when i do this query:
>
> select *, id as vid, user_id as uid from video where (file_complete =
> 'true') order by undt desc limit 0,10;
>
> the results are 0.16 or 0.17 seconds.
>
> instead of saying file_complete = 'true. if i say file_complete != to the
> other 5 possible enum values. the query returns in 0.00 sec.
>
> there is an index on that field... shouldn't the = 'true' query be faster?
> i just dont understand.
>
Are there more rows returned for 'true' than for the other values?
Have you tried using something other than a reserved word for 'true'?
What other values for file_complete could there be than true and false?
Why not define e.g. upload_status enum ('working', ...., 'complete').
(BTW you don't need those (parentheses) in your query.)
-J
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|