Hello guys, Let say: UPDATE some_table SET some_field=1 WHERE id = some_id and UPDATE some_table SET some_field=0 WHERE id <> some_id
what I can do to merge these queries? The first thing that came up in my mind was something like that: UPDATE some_table SET some_field=1 WHERE id = some_id; SET some_field=0 WHERE id <> some_id; so we can walk-through table only once... What do you think? Regards, July<a href='http://mail.bg/ads/adclick.php?bannerid=860&zoneid=13&source=&ismap=' target='_blank'><p>СТАНТЕК - http://www.stantek.com<br/> компютри за дома и офиса,<br/> коректно обслужване,<br/> партньорство и добри цени</p></a><div id="beacon_860" style="position: absolute; left: 0px; top: 0px; visibility: hidden;"><img src='http://mail.bg/ads/adlog.php?bannerid=860&clientid=273&zoneid=13&source=&block=0&capping=0&cb=522e3492978f772735809616c5e107b2' width='0' height='0' alt='' style='width: 0px; height: 0px;'></div>