Jump to content

Archived

This topic is now archived and is closed to further replies.

brown2005

update numerous records

Recommended Posts

If i have

1, 2, 3, 4, 5

how can i update table1 field number for 5 records randomly?

Share this post


Link to post
Share on other sites
you helped me on my other topic and you gave me

UPDATE table2 SET `fieldname` = (SELECT letter FROM table1 ORDER BY RAND())

but that didnt work..

what i want to do is

take say 10 records from one table....

and update a field in 10 records from a different table but using the 10 above randomly

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.