help with mysql query
Posted by: Lisa Raeburn
Date: November 05, 2010 02:56PM
I need to search within my mysql database for shared values between two different samples (ie. If i have a venn diagram, with two intersecting circles, I need to determine the value of counts in the intersect)- what variables are the same between 01-N and 01-B?
I think I may need perl to do this, but I am quite new to both perl and MySQL and am having some trouble.
right now my query looks something like this:
select * from table where sample.name = "01-N" and sample.name = "01-B"
any help would really be appreciated.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.