Posted by Piratron on 06/09/06 00:03

Hi ppl,

I need help regarding table search.

This is the table structure
----------------------------
thank_id int(10)
member_id int(10)
topic_id int(10)
post_id int(10)
thank_date int(10)
----------------------------

I need mysql code which will perform search through this table and find
unique
member_id where topic_id are various sets of 50 or more integers.
actually I'll need to find a member who posted in all those topics that
I'm searching...

please note that this table has more than 50,000 rows thus one instance
ofr topic_id can return more than 200 rows.

I need this code only to find one member_id, it doesnt have to be ultra
fast ;)

thanks in advance,

regards,

Piratron


--
------------------------------------------------------------------------
visit our site at:
www.symbian-mobile.org

Regards,
Symbian-Mobile Team

• Next in forum: Mysql question
• Prev in forum: Re: mysql hosting
• Thread view: advanced search through table

[Reply to this message]