Posted by carrajo on 02/15/06 17:08

This works. Thanks for all your help guys.

select users.*
from users
where uid in (select uid from user_answer
where answer in ('Brown Hair', 'Single', 'Tall'))
and uid not in (select uid from user_answer
where answer not in ('Brown Hair', 'Single', 'Tall'))

OR (uid in (select uid from user_answer where answer = 'Brown Hair')
and uid in (select uid from user_answer where answer = 'Single')
and uid in (select uid from user_answer where answer = 'Tall')
)

• Next in forum: Re: Guestbook with multiple host-pages
• Prev in forum: Re: MySQL searching only Criteria
• Thread view: Re: MySQL searching only Criteria

[Reply to this message]