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


Subject
Views
Written By
Posted
query optimization
2529
March 12, 2010 06:12AM
1599
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.