Would like to change order status throgh Magento 2 MySQL Query
But Order Status belongs to so many tables like
Need to use
sales_order_status_state what's difference between Status & State?
Example: Status is fraud, but Stat is payment_review.
Can use below method to update order status
$update = $collection->update('sales_order', [ 'status' => 'complete', ], ["entiry_id = ?" => 1] );
In how many tables I have to change status? Will don't have like update in 1 table & changes will be applied in respective relational tables.
How to update multiple tables at same time
$update = $collection->update('sales_order','sales_order_grid'