MYSQL query for search page

[leony]

Hi

 

I have a MYSQL query for my searc page. How can I assign more importance to "title" column than "body_text2 column?

 

$sql = "SELECT *, MATCH(title, body_text) AGAINST ('$keyword') AS score FROM my_table WHERE MATCH(title, body_text) AGAINST('$keyword') ORDER BY score";

 

 

[cooldude832]

you  can add to the order by clause and add the columns you want first higher.

[Maq]

If you mean you want to score to be the most important than title do this:

 

$sql = "SELECT *, MATCH(title, body_text) AGAINST ('$keyword') AS score FROM my_table WHERE MATCH(title, body_text) AGAINST('$keyword') ORDER BY score, title";