By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,377 Members | 1,660 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,377 IT Pros & Developers. It's quick & easy.

Search Query

P: 8

I have a database of 100million rows and need to do a like statement with "%test%". I understand that it does not use an index and it is really slow and resource intensive.

Is there a way to use a Full Text search to get the middle of words? I know you can use word beginnings like '"test*"' but what about '"*test*"' and return the same results as a like "%test%"

For example:
I need to search "abas" and return results like "database".

Any suggestions or am I stuck with the like statement?
Sep 21 '12 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,208
i don't see why '"*test*"' wouldn't return the same results as like "%test%"

Expand|Select|Wrap|Line Numbers
  1. select name from blah where contains(name, '"*test*"')
Sep 22 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.