INSERT INTO history (type,name,value) VALUES ( 0 , , 1 ) SELECT DATA FROM cache WHERE name = 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 INSERT INTO cache (name,data) VALUES ( , )