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