Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Slow: function prevents index use SELECT * FROM users WHERE YEAR(created_at) = 2024; -- Fast: range condition uses index SELECT * FROM users WHERE created_at >= '2024-01-01' AND created_at < '2025-01-01';
Result
Open