Hi,
I'm currently working on a project which uses fuulltext searching. The
with query expansion feature is useful, but I was wondering if there's
any way to obtain the list of terms that the expanded query uses (other
than those originally input, of course). Is that possible, and, if so, how?
Hello,
I need some help optimizing a query. The current query is as follows:
SELECT *,
MATCH(title) AGAINST ( 'S' IN BOOLEAN MODE ) AS score
FROM articles
WHERE MATCH(title) AGAINST ( 'S' IN BOOLEAN MODE );
'title' is a FULLTEXT index.
'S' is a query string that may have 100 search
100 search items is a lot to search on at once for any system. MySQL
has to search on a 100 terms, no way around that.
I think the only way to optimize your query is to narrow down the
search terms. Perhaps you can search on phrases instead of words?
After the first 5-10 terms have been
I want to have the query cited at the very bottom return a result sorted
by FullText Relevance. I'm thinking I would modify each SELECT
separately. For example maybe the first SELECT clause something like:
SELECT page.* FROM `page` LEFT JOIN `keywords` USING (`page_id`), MATCH
Hi!
On Mar 21, Shane Allen wrote:
I've read through the boolean mode fulltext docs, and they address all
my questions well except how searches containing exact phrases are
handled when there is more than one. I believe the following will work
as I expect, but was wondering if anyone can
I've read through the boolean mode fulltext docs, and they address all
my questions well except how searches containing exact phrases are
handled when there is more than one. I believe the following will work
as I expect, but was wondering if anyone can confirm it for me:
Given the following
Hi!
I have 2 tables
Table 'candidate_index' holds information like
firstName,lastName,phoneNumber etc.
Example
id | firstName | lastName | phoneNumber
1 | Peter | Engström | 3236363
2 | John| Smith | 3773737
...
Table 'candidate_skills' holds the skills a candidate have
Dear listmembers,
I have two tables
candidate_index
candidate_skill
candidate_index hold information about the candidate like id
(autoincrement), firstName, lastName
and emailAddress.
candidate_skill has three columns
- id (autoincrement)
- candidateID
- skill
client_index has a fulltext
Dear members,
Wish you a Happy New Year 2002
I created FullText Index and in the sql using 'where match(...,,)
against ('searchstring')'. It is working fine for exact full words. How to
operate for pharses i.e.
The query should fetch even if the search string is substring of a column
Hi,
I have some problems with the Fulltext query it doesn't
seem to function as I aspect. E.g. I have a table with a
Fulltext index on columns title and description.
If I query for:
SELECT node_id, title FROM node WHERE MATCH (title,description)
AGAINST('bil');
(bil is car in Danish) it doesn't
10 matches
Mail list logo