Re: How to query this table

[Mike Clemens]

Like this?

SELECT userId
FROM userProfileData
WHERE fieldName = 'emailSubscribe'
AND fieldData = 'yes'

This would give you back a list of userId that wanted to subscribe. If you're running mySQL 4.1, then you could bury this in a subquery:

SELECT fieldData
FROM userProfileData
WHERE fieldName = 'email'
AND userId IN (SELECT userId
FROM userProfileData
WHERE fieldName = 'emailSubscribe'
AND fieldData = 'yes')

If you're not running 4.1, then you should be able to join the table on itself, although this would not be a good idea if the table is large:

SELECT u1.fieldData
FROM userProfileData u1, userProfileData u2
WHERE u1.userId = u2.userId
AND u1.fieldName = 'email'
AND u2.fieldName = 'emailSubscribe'
AND u2.fieldData = 'yes'