I am executing the following code..
<sum "%s" "/" $q ".php"> where query is insulin
<$urlquery = $ret>
<SQL "select count(*) mycount from html where Url likep $urlquery"></SQL>
I have created a metamorph Inverted index on Url
But this isn't giving me any results..whereas there are Urls in my database like www.fasthealth.com/i/insulin.php
It gives me a message saying the query wud require linear search, which wud be slow..Is there a way to specify while creating the index so that special characters like / and . are a part of index
Thanks..
<sum "%s" "/" $q ".php"> where query is insulin
<$urlquery = $ret>
<SQL "select count(*) mycount from html where Url likep $urlquery"></SQL>
I have created a metamorph Inverted index on Url
But this isn't giving me any results..whereas there are Urls in my database like www.fasthealth.com/i/insulin.php
It gives me a message saying the query wud require linear search, which wud be slow..Is there a way to specify while creating the index so that special characters like / and . are a part of index
Thanks..