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