brown2005 Posted April 12, 2006 Share Posted April 12, 2006 If i have1, 2, 3, 4, 5how can i update table1 field number for 5 records randomly? Quote Link to comment Share on other sites More sharing options...
shocker-z Posted April 12, 2006 Share Posted April 12, 2006 huh?? Dont get what you mean.. Quote Link to comment Share on other sites More sharing options...
brown2005 Posted April 12, 2006 Author Share Posted April 12, 2006 you helped me on my other topic and you gave meUPDATE table2 SET `fieldname` = (SELECT letter FROM table1 ORDER BY RAND())but that didnt work..what i want to do istake say 10 records from one table....and update a field in 10 records from a different table but using the 10 above randomly Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.