How to query a specific partition using list partitioning mechanism??

[Parames Kalidas]

Hi,
Can anyone please tell how to get the data from a specific partion using list partition.

I have a table with 4 partitions as below:

DROP TABLE IF EXISTS `test`.`clientdetails`;
CREATE TABLE `test`.`clientdetails` (
`ID` int(10) unsigned NOT NULL,
`Client_ID` int(10) unsigned NOT NULL,
`Name` varchar(45) NOT NULL,
`Region` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY LIST (Client_ID)
(PARTITION tr VALUES IN (1) ENGINE = InnoDB,
PARTITION ggl VALUES IN (2) ENGINE = InnoDB,
PARTITION eds VALUES IN (3) ENGINE = InnoDB,
PARTITION hp VALUES IN (4) ENGINE = InnoDB) */;

How can i retrieve the data specific to let say partition "tr"? Any suggestions will be highly appreciated.

Thanks in advance....
Warm Regards,
Parames