Jandal
-
Posts
1 -
Joined
-
Last visited
Never
Jandal's Achievements
Newbie (1/5)
0
Reputation
-
Hello Elgan, Did you get the score to work? I am trying to do a similiar query to you. I have a query like this [code] SELECT *, MATCH( tableA.name ) AGAINST('$search') OR MATCH( tableB.text ) AGAINST('$search') AS score FROM tableA INNER JOIN tableB ON tableA.id = tableB.id WHERE MATCH( tableA.name ) AGAINST('$search') OR MATCH( tableB.text ) AGAINST('$search') ORDER BY score DESC; [/code] But the problem is that all of my scores are 1 which doesn't help with the indexing. Do you have any tips please? Thanks in advance, Jandal =-)