Facebook query language. Get all user live in california

Question

I am working in facebook Application MVC 4 c# SDK 6

is there any way to get the list of all Facebook User. Either friend or not, who lives in California using Facebook Query Language

Answer 1

List of your friends who live in California and have it list in their current location.

SELECT name, current_location
FROM User 
WHERE uid IN (SELECT uid2 FROM Friend WHERE uid1 = me())  
      AND current_location.state = "California"

Test out the query here.

I don't think it's possible to pull this information on all Facebook users since the location column is not indexed. This answer does a good job explaining why searching by location along is not possible.

Helpful links:

• how to write an fql query to list friends in a particular location
• From FQL we want to get users current location in php