How to influence the relevance of MySQL fulltext search?

Question

PHP

Columns in the table: id, text, source I
use the usual query:

SELECT * FROM `articles` WHERE MATCH (text) AGAINST ('database');

...how can I make search results\rows with the word "auto" in the 'source' column ranked with higher priority than other rows?
Thank you!

Answer 1

Lines with 'auto' are always in front:

SELECT * 
    FROM (
        SELECT *, MATCH `text` AGAINST('database') AS `score`
            FROM `articles`
    ) AS `t`
    WHERE `score` > 0
    ORDER BY `source` != 'auto', `score`

Lines with 'auto' have more weight (+0.5):

SELECT *
    FROM (
        SELECT *, MATCH `text` AGAINST('database') AS `score`
            FROM `articles`
    ) AS `t`
    WHERE `score` > 0
    ORDER BY `score`+(`source` = 'auto')*0.5 DESC