DELETE from cart
WHERE product_id NOT IN( SELECT id FROM products where status = 'enabled')
AND user_id = '90'
The above is what I would like it to do, though I can not test it as I do
not have access to a mysql that supports it.
Aside from two queries, can someone perhaps show me how to run
DELETE from cart
WHERE product_id NOT IN( SELECT id FROM products where status = 'enabled')
AND user_id = '90'
The above is what I would like it to do, though I can not test it as I do
not have access to a mysql that supports it.
Aside from two queries, can someone perhaps show me how