SELECT id FROM users WHERE active=1 AND about_me LIKE "%#майнатаун%" ORDER BY username ASC, num_followers DESC
0.00908
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#майнатаун($|\,)" ORDER BY username ASC
0.01309
SELECT id FROM users WHERE active=1 AND (username LIKE "%#майнатаун%" OR fullname LIKE "%#майнатаун%" OR position LIKE "%#майнатаун%") ORDER BY username ASC
0.01165
SELECT id FROM users WHERE active=1 AND (username="#майнатаун" OR fullname="#майнатаун" OR position="#майнатаун") ORDER BY username ASC