SELECT id FROM users WHERE active=1 AND about_me LIKE "%#valentinesday%" ORDER BY username ASC, num_followers DESC
0.01184
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#valentinesday($|\,)" ORDER BY username ASC
0.01575
SELECT id FROM users WHERE active=1 AND (username LIKE "%#valentinesday%" OR fullname LIKE "%#valentinesday%" OR position LIKE "%#valentinesday%") ORDER BY username ASC
0.01379
SELECT id FROM users WHERE active=1 AND (username="#valentinesday" OR fullname="#valentinesday" OR position="#valentinesday") ORDER BY username ASC