SELECT id, titel, MATCH (titel) AGAINST ('moz*' IN BOOLEAN MODE) AS
score FROM cmp_composities WHERE MATCH (titel) AGAINST ('moz*' IN
BOOLEAN MODE)
+--
+---
+---+
| id | titel
| score |
+--
Further to my Full Text question the other day, I'm trying to add the
parimetric data to the field that gets searched.
We have a script that runs periodically to update this table. I can do
what I want in that script no problem, but it would be more elegent if
I could acheive the same results
Hi All,
I'm currently engaged in a project to implement full text searching
of our product database. The current implementation was written for an
older version of MySQL and doesn't implement BOOLEAN MODE.
Currently, the full text search is against a de-normalised table from
fields icluding the
