Re: "MATCHES A*" within a query

Well, assuming that you have an index that {field} is the leading column of, yes it is likely to use it. This is because you have provided the leading character, of which the index is based on. Use SET EXPLAIN to see the optimizer's actual index selection. -Bill } } If I have a select statement in the form: } } select {various fields} where {field} MATCHES "A*" } } Will this query utilise an index or do I have to get rid of the "MATCHES" } clause and then use something like perl to actually extract my data? } } Thanks } Tan } } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison emails: ennis@ssax.com ennis@starnetusa.com