PDA

View Full Version : SQL Query question


T3MEDIA
10-06-2005, 11:47 AM
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
10-06-2005, 02:00 PM
Something like this you after?


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