Most efficient way of storing and retrieving rows in a table based on location coordinates?

Imagine I run a website that stores user-submitted content along with the location coordinates of the user. and I want to serve users with content created close to their own location. How would I design the database to retrieve rows while minimizing table scans?