Getting hobbies in FQL

Selecting all friends who are interested in a particular hobby should be easy, right?
Well, it is, provided you're happy to do subselects, and realise the hobbies come back as a giant string.
Luckily, all that hard work can be pushed off to the FQL server...

---

SELECT name
FROM user
WHERE uid IN (
  SELECT uid2
  FROM friend
  WHERE uid1 = '$me'
)
AND (
 strpos(activities, '$hobby') >= 0 OR
 strpos(interests,  '$hobby') >= 0
)