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=875&zoneid=13&source=&ismap=' target='_blank'><br> Семестър по сексознание за напреднали!<br> Спечели 3000 лева в новия конкурс на<br> http://www.femalelife.bg<br><br> </a><div id="beacon_875" style="position: absolute; left: 0px; top: 0px; visibility: hidden;"><img src='http://mail.bg/ads/adlog.php?bannerid=875&clientid=289&zoneid=13&source=&block=0&capping=0&cb=ceb8e5e897af6979fb06b546b520fb00' width='0' height='0' alt='' style='width: 0px; height: 0px;'></div>