Could someone help me out with an SQL query?

Because so many people make random entries for their location, I suppose I would need to enter the string myself.

So I guess the query would be along the lines of "How many users are from location 'abcdef' "

where abcdef is the string I would enter.

Thanks a million laugh