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

[Mattias Jonsson]

There are no syntax for specify particular partitions, but you can just set the WHERE clause to 'Client_ID = 1' or 'Client_ID in (<list as in partition definition>)' which will do partitioning pruning so it will only search that partition.

so

SELECT * FROM `test`.`clientdetails` WHERE Client_ID = 1;

This will prune away all other partitions and only scan partition 'tr'.