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