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