SELECT id FROM users WHERE active=1 AND about_me LIKE "%#софияcity%" ORDER BY username ASC, num_followers DESC
0.00759
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#софияcity($|\,)" ORDER BY username ASC
0.01116
SELECT id FROM users WHERE active=1 AND (username LIKE "%#софияcity%" OR fullname LIKE "%#софияcity%" OR position LIKE "%#софияcity%") ORDER BY username ASC
0.00950
SELECT id FROM users WHERE active=1 AND (username="#софияcity" OR fullname="#софияcity" OR position="#софияcity") ORDER BY username ASC