MySQL 8.0 C API Developer Guide
MYSQL_ROW_OFFSET
mysql_row_seek(MYSQL_RES *result,
               MYSQL_ROW_OFFSET offset)
          Sets the row cursor to an arbitrary row in a query result set.
          The offset value is a row offset, typically
          a value returned from
          mysql_row_tell() or from
          mysql_row_seek(). This value
          is not a row number; to seek to a row within a result set by
          number, use mysql_data_seek()
          instead.
        
          This function requires that the result set structure contains
          the entire result of the query, so
          mysql_row_seek() may be used
          only in conjunction with
          mysql_store_result(), not with
          mysql_use_result().
        
          The previous value of the row cursor. This value may be passed
          to a subsequent call to
          mysql_row_seek().