如何获取mysql表中某行的分区名

CREATE TABLE my_table (
    id INT,
    name VARCHAR(50)
) PARTITION BY RANGE (id) (
    PARTITION p0 VALUES LESS THAN (100),
    PARTITION p1 VALUES LESS THAN (200),
    PARTITION p2 VALUES LESS THAN (MAXVALUE)
);

SELECT PARTITION_NAME
FROM information_schema.PARTITIONS
WHERE TABLE_NAME = 'my_table'
    AND PARTITION_METHOD = 'RANGE'
    AND TABLE_SCHEMA = 'your_database_name'
    AND 100 >= PARTITION_DESCRIPTION;