SELECT id FROM users WHERE active=1 AND about_me LIKE "%#ливърпул%" ORDER BY username ASC, num_followers DESC
0.00780
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#ливърпул($|\,)" ORDER BY username ASC
0.01063
SELECT id FROM users WHERE active=1 AND (username LIKE "%#ливърпул%" OR fullname LIKE "%#ливърпул%" OR position LIKE "%#ливърпул%") ORDER BY username ASC
0.00929
SELECT id FROM users WHERE active=1 AND (username="#ливърпул" OR fullname="#ливърпул" OR position="#ливърпул") ORDER BY username ASC