I need to search AU users by more than just username - actually by location, bio or website. Is this possible? In the users tab search only works by username only.
Moderators can search by a few extra terms. If you desperately need to find a person —and have a good reason— bug one of us and we'll try to help you.
Additionally the public data is accessible through data.stackexchange.com. You can compose a SQL query to search from a number of fields, including location, bio and website. Here's a simple search on the bio field which finds my user:
SELECT * from Users where AboutMe like '%thepcspy%'
Note that the data.SE engine works on a slightly old database. I don't know what the delay is these days but it isn't current. It should be good enough for most purposes though.
You can also download the SE Data Dumps and do things manually... Though they are 25GB compressed.
Thanks man. Just wanted to find the Kenyans in here and invite them to an Ubuntu Kenya Meet-Up organized by my friend (the guy who introduced me to Ubuntu) and I. Is that a good enough reason? Mar 25, 2015 at 14:57
I don't think we can search by country (just names, email, etc). You'd be best off with data.stackexchange:
SELECT * from Users where AboutMe like '%kenya%' or Location like '%kenya%'– Oli ModMar 25, 2015 at 15:00
The query works but I don't appear on the list - weird... Mar 25, 2015 at 15:45
also found this for Moroccan users - data.stackexchange.com/askubuntu/query/292699/… Mar 25, 2015 at 15:47
1Yeah wrapping the field in
LOWER()did the trick:
SELECT * from Users where LOWER(AboutMe) like '%kenya%' or LOWER(Location) like '%kenya%'finds 132 rows.– Oli ModMar 26, 2015 at 10:22