UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support SQL query on Location field

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

If it's an exact string, you can remove the % around the string. % is a wildcard, so the above would match hooboo, boo, boohoo, etc.

Rick comes up trumps again.

Thanks

bump for me