Dear list, I want to display the result of the some mysql query differently .. I have a mysql table(allreps_orgs) with 2500,000 entries.
QUERY IS: select distinct * from allreps_orgs as p1,allreps_orgs as p2, where p1.organism='Plasmodium' AND p2.organism='Caenorhabditis' AND p1.repeat=p2.repeat; ---------- It displays the result correctly. But it joins two entries having same values in repeat coloum. the typical result row looks like this. |16804919|LKEKE|5|2|Plasmodium|1|155|22329777|LKEKE|5|2|Caenorhabditis|4|234| In which first 7 columns are coming from one row and next 7 are from another row which are satisfying the condition. I want these to be displayed in two different rows (first 7 in row 1 and second 7 in row 2). Is it possible to that. I could do it by displaying p1.* and p2.* in two different quries. But that doubles the querying time. Any other suggestions or pointers. following is my table structure. Note: i compare blob filed which is indexed in first 10 char. +----------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------------+------+-----+---------+-------+ | prot_id | varchar(15) | YES | MUL | NULL | | | repeat | blob | YES | MUL | NULL | | | size_rep | int(10) unsigned | YES | | NULL | | | freq | varchar(5) | YES | | NULL | | | organism | varchar(100) | YES | | NULL | | | version | char(3) | YES | | NULL | | | cordis | blob | YES | | NULL | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
