Search results for query: *

Thanks r937, Our posts crossed in cyberspace, and it is good we agree. Regards, Robin

Hi, I think I have solved this with the following:- UPDATE wsnlinks_links numcomments SET numcomments=119 WHERE numcomments < 60 This updates numcomments to a value of 119 if the value of numcomments is less than 60 Thanks for any observations. Regards, Robin

I need to select certain records and then replace then with a new value. I have been searching through the manual and also on this forum board but to no avail. I have tried loads of different combinations but can not find the answer. I can select my records using the following:- SELECT...

Hi, Further to my original query, is it possible to update phpbb_banlist conditionally, i.e. If phpbb_banlist ="30" then UPDATE phpbb_banlist SET ban_userid = "33"; or If phpbb_banlist ="30" then UPDATE phpbb_banlist SET ban_userid = "33"; otherwise phpbb_banlist ="6" Thanks, Robin

Thank you, really appreciated. Robin

Hi, I have a mysql database and I want to reset the values of one of the numerical fields to another numerical value. By using the following I can change the value of all of the fields which are '1' to '33' but what I want is not to put a value in for the existing values in the field but have...