I have a situation where I am doing lots of complex sorting on records that
already exist in a MySQL table. The table has a 'sort_order' field which
means I can do a simple ORDER BY sort_order to keep it nice and quick on
SELECT, it's only UPDATE which is slow.
If I change the order that I want 10000 rows to be displayed, I am currently
making 10000 SQL queries such as:
UPDATE products SET sort_order=0 WHERE id='5';
UPDATE products SET sort_order=1 WHERE id='2';
UPDATE products SET sort_order=2 WHERE id='32';
and so on.
Obviously I'd love to be able to put all of this into one query.
Is there some way I can combine this with IN() ?
UPDATE products set sort_order=**** WHERE id IN('5','2','32');
Many thanks in advance for any help / advice.
Best wishes,
Steve
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
