SQL Query question

[T3MEDIA]

What would be the SQL query to find members from say Europe?
The user profile id is field13, this is a Single-Selection Menu.

[soniceffect]

Something like this you after?

[sql]
SELECT A.username, A.field13
FROM userfield A
INNER JOIN
user B
ON A.userid=B.userid
WHERE A.field13 like '%europe%'
[/sql]