Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Page 2 (10 results per page) SELECT id, title, MATCH(title, body) AGAINST('mysql') AS score FROM articles WHERE MATCH(title, body) AGAINST('mysql') ORDER BY score DESC LIMIT 10 OFFSET 10; -- Count (can be expensive on large tables) SELECT COUNT(*) FROM articles WHERE MATCH(title, body) AGAINST('mysql');
Result
Open