Please look at the table data carefully. I need to delete the rows. I need urgent help..!!
CREATE TABLE IF NOT EXISTS `version` ( `nidt` varchar(11) NOT NULL, `noeud` tinyint(3) NOT NULL, `VERSION` float NOT NULL, `ETAT_FONCT` varchar(20) default NULL, `idnap` varchar(25) NOT NULL, `nidtint` bigint(20) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
For SAME nidt & SAME noeud, i would like to DELETE rows based on two condition:
If ETAT_FONCT = "OPERATIONAL" Delete REST ROWS EXCEPT HIGHEST Version
If ETAT_FONCT != "OPERATIONAL" DELETE Older verions
Thanks in advanced for input. :) :)