UPDATE is not good enough in MYSQL

[Ben-Nes Michael]

Hi I wanted to do :

UPDATE  products SET Weight = '0.5' FROM products,  rank WHERE
products.code = rank.code AND category = 'bell';

And got answered that its impossible and all I can do is first do a
select then update the results.
This is a good solution only when i mange few items, but when i get back
hundreds of items its not enough.

UPDATE is one of the most important command in the MySQL and most go
some improvement (unless i don't know something).

How can i contact the developers about this problem ?
--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: [phone]
Fax: [phone]
http://www.canaan.co.il
--------------------------