MySQL 8.0 C API Developer Guide
void
mysql_data_seek(MYSQL_RES *result,
uint64_t offset)
Seeks to an arbitrary row in a query result set. The
offset value is a row number. Specify a
value in the range from 0 to
mysql_num_rows(result)-1.
This function requires that the result set structure contains
the entire result of the query, so
mysql_data_seek() may be used
only in conjunction with
mysql_store_result(), not with
mysql_use_result().