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