Re: "MATCHES A*" within a query
--------------CD662F8BBA860A7AAF998EA2 Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit As about myself, I prefer to make an experiment. Set explain on and run the query. Than look into sqlexplain.out. :) Mike tan wrote: > 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 -- ------------------------- The early bird who catches the worm works for someone who comes in late and owns the worm farm. -- Travis McGee --------------CD662F8BBA860A7AAF998EA2 Content-Type: text/html; charset=koi8-r Content-Transfer-Encoding: 7bit <HTML> As about myself, I prefer to make an experiment. Set explain on and run the query. Than look into sqlexplain.out. :) <BR>Mike <P>tan wrote: <BLOCKQUOTE TYPE=CITE>If I have a select statement in the form: <P>select {various fields} where {field} MATCHES "A*" <P>Will this query utilise an index or do I have to get rid of the "MATCHES" <BR>clause and then use something like perl to actually extract my data? <P>Thanks <BR>Tan</BLOCKQUOTE> <PRE>-- ------------------------- The early bird who catches the worm works for someone who comes in late and owns the worm farm. -- Travis McGee</PRE> </HTML> --------------CD662F8BBA860A7AAF998EA2--