likep

sourceuno · Post by **sourceuno** » Wed Jun 27, 2001 3:41 pm

I have a table similar to the html table from the dowalk_beta script. Here's the definition of the metamorph index:
create metamorph inverted index xhtmlbod on html(Title\Description\Keywords\Body)

I want to perform a keyword search that only search the keyword field of a record along with a full text search that searches only the Title and Body fields. When I try the following query,

<sql "select 'http://'+Url Url, Title, $$rank Rank from html where Title\Body\Metadata likep $defaultquery and Keywords like $keywordquery"></sql>

I get the following error:


How would I propery construct the query to do what I need?

Post by **mark** » Wed Jun 27, 2001 3:48 pm

You need to create separate indices on the fields the way you want to search them. One on Title\Body\Metadata and one on Keywords.

sourceuno · Post by **sourceuno** » Wed Jun 27, 2001 5:17 pm

Would I keep the index on Title\Body\Metadata as a metamorph index? What type of index would I use on the field Keywords?

Post by **mark** » Wed Jun 27, 2001 5:28 pm

like and likep both use metamorph [inverted] indices.

sourceuno · Post by **sourceuno** » Wed Jun 27, 2001 5:31 pm

I thought that I read somewhere that you should only have 1 metamorph index on a table. Are you saying that I need to create a metamorph index for Title\Body\Metadata and a separate one for Keywords?

Post by **mark** » Wed Jun 27, 2001 5:35 pm

I'm not sure where you got that. If you find it again let me know where.
You may have as many indices of any type as are needed.