From: Jin Hui
Date: March 29 1999 1:13am
Subject: Question about query
List-Archive: http://lists.mysql.com/mysql/1110
Message-Id: <50E89D0739DBD1119B5500A0C932C7E6880FBD@exchsrv.ubisoft.com.cn>
MIME-Version: 1.0
Content-Type: text/plain

Hi,

I have a query like
select id from atable where truncate(c1/1000000) = 321

I learned that following query has the same function
select id from atable where c1 like '321______'

I'd like to know which is faster. Or anyone know how to do integer division
in MySQL faster.

And if I make a index on c1 or a index on c1/1000000, which index will
increase the query speed, or none index is helpful. 

Thanks!

Best Regards,
Jin Hui