an example would be
Code:
Update doors SET opentype=58, dest_zone='poknowledge', dest_x=100, dest_y=10, dest_z=3 where id=343;
Open type 58 will port on clicking, dest_... says wher it sends you.
Now before you go do anything, I suggest you go read some of the mysql documentation so that you know what that actually does. I also suggest you get and use MYsql Control Center (or mysql-Front) to work with mysql data.
The docs and MYsql Controll Center can be found at
http://www.mysql.org