mysql query

[chris1979]

I haven't used signatures on my forum before but I'd like to start.

To get started, is there a way I can use mysql to put whatever people have as their homepage into the signature field. I know how I'd do this if they were in the same table,

e.g. UPDATE user SET signature = homepage;

but in this case I think signature is in the usertext table and homepage is in the user table.

Any idea how I can do this then?