rsiedl Posted May 16, 2007 Share Posted May 16, 2007 hi, i have a database with the following: Table structure (search_stats): +---------+------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | PMID | int(11) | | MUL | 0 | | | PMkey | varchar(4) | | MUL | | | | PMvalue | longtext | | | | | +---------+------------+------+-----+---------+----------------+ Sample data: +-------+----------+-------+---------+ | id | PMID | PMkey | PMvalue | +-------+----------+-------+---------+ | 27941 | 7321569 | MH | Female | | 27976 | 293324 | MH | Adult | | 27982 | 293324 | MH | Female | | 28039 | 1168727 | MH | Female | | 28164 | 4493249 | MH | Female | | 28165 | 4493249 | AD | Brazil | | 28206 | 5545272 | MH | Adult | | 28214 | 5545272 | MH | Female | | 28252 | 5841289 | MH | Female | +-------+----------+-------+---------+ can anyone suggest how i would write an sql statement to do something like: select PMID from search_stats where MH="Female" and AD="Brazil" (which should return just the PMID of 4493249) * the above statement is just to demonstrate what i am trying to achieve cheers, reagen Quote Link to comment https://forums.phpfreaks.com/topic/51605-sql-query-over-multiple-rows/ Share on other sites More sharing options...
bubblegum.anarchy Posted May 16, 2007 Share Posted May 16, 2007 Use the JOIN syntax Quote Link to comment https://forums.phpfreaks.com/topic/51605-sql-query-over-multiple-rows/#findComment-254249 Share on other sites More sharing options...
fenway Posted May 18, 2007 Share Posted May 18, 2007 You actually need a self-join for this... Quote Link to comment https://forums.phpfreaks.com/topic/51605-sql-query-over-multiple-rows/#findComment-256663 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.