--- In ydn-php@yahoogroups.com, "abhijit4u_2005" <abhijit4u_2005@...>
wrote:

>
> I want to retrieve those name whose last name starts with any alphabet
> (e.g T%) but the problem is on that table there are more then 8lakhs
> entries are there,it's take lot of time, the database is: MySql and
> query as follows:
> "SELECT name FROM `userinfo01` where `lastName` like 'T%'"
>
> some body help me that how can i optimize that query????????
>

Maybe you can try explain to verify your performance of query.