MySQL allows you to do regular expressions using RLIKE. I don't know how the performance compares to using LIKE though. e.g.
SELECT * FROM my_table WHERE my_field LIKE '%foo%' or my_field LIKE '%bar%';
SELECT * FROM my_table WHERE my_field RLIKE '.*(foo|bar).*';
Here's the page in their doc:
How would that possibly be faster? Also you might get queries like
field LIKE '%a%' AND (field LIKE '%b%' OR field LIKE '%c%')
I was looking for a product like Lucene but for partial string matching.
Notify me of follow-up comments via email.