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