SELECT id, name , ( (1.4 * (MATCH( keywords ) AGAINST ( IN BOOLEAN MODE))) + ( .7 * (MATCH( name ) AGAINST ( IN BOOLEAN MODE))) ) AS score FROM resource WHERE ( MATCH( name, keywords ) AGAINST ( IN BOOLEAN MODE) ) HAVING score > 0 ORDER BY score DESC