Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
SELECT id, title, (MATCH(title) AGAINST('mysql') * 3 + MATCH(body) AGAINST('mysql')) AS weighted_score FROM articles WHERE MATCH(title, body) AGAINST('mysql') ORDER BY weighted_score DESC;
Result
Open