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