How to update Auto increment value in single column field using a single query

Go to your database ->SQL
and add the following query like your table field


SET @ordering = 0; UPDATE table SET increment = (@ordering := @ordering + 1) WHERE field = 'value' ORDER BY order_field;