Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Slow: full table scan, no ranking SELECT * FROM articles WHERE body LIKE '%optimization%'; -- Fast: uses full-text index, ranked by relevance SELECT *, MATCH(title,body) AGAINST('optimization') AS score FROM articles WHERE MATCH(title,body) AGAINST('optimization') ORDER BY score DESC;
Result
Open