Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Index both title and body ALTER TABLE articles ADD FULLTEXT idx_ft (title, body); -- Search across both columns SELECT id, title FROM articles WHERE MATCH(title, body) AGAINST('performance tuning') ORDER BY MATCH(title, body) AGAINST('performance tuning') DESC;
Result
Open