/* -------------------------------------- */


/* Select some rows from the tickets */
SELECT ticket_id,date,subject,closed, MATCH(subject, body) AGAINST ('') AS SCORE FROM tinima_tickets

/* Match */
WHERE MATCH(subject, body) AGAINST ('')



/* Order */
ORDER BY score DESC LIMIT 0,15


/* -------------------------------------- */