| Text based search [message #76041] |
Tue, 22 April 2003 21:52  |
Senthil
Messages: 68
Registered: December 1999
|
Member |
|
|
I have a 80 character Name field in my customer table. My table contains
more 500,000 records. I want to search on any portion of the name field.
When I use the %search text% option, the search is taking a long time. I have tried the Inter Media text based index. Even there a %word% search is taking a long time. Is there an alternative ?
|
|
|
|
| Re: Text based search [message #76043 is a reply to message #76041] |
Mon, 12 May 2003 17:19  |
Todd Barry
Messages: 4819
Registered: August 2001
|
Senior Member |
|
|
If you want your query to use the interMedia index, you do not use the LIKE '%word%' syntax. There is a special function (CONTAINS) that you use instead.
where contains(name, 'word') > 0 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
