MySQL Forums
Forum List  »  Optimizer & Parser

query optimization
Posted by: amol deshpande
Date: March 12, 2010 06:12AM

I have table for stopwords with field stopword in which i will be having values a regular expression.
If a user try to register, i want to check if the name is present in the stopword table. I have built a query for the same, please optimize this query if possable

select count(stopword) from stopwords where 'test' REGEXP stopword

Options: ReplyQuote

Written By
query optimization
March 12, 2010 06:12AM
March 13, 2010 09:11AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.