Log in

View Full Version : quick mysql help needed!


reesev
02-23-2008, 11:29 PM
i want to run the following query for all forums

UPDATE `p2ptalk_forum`.`forum` SET `allowprefix` = '0',
`prefixrequired` = '0' WHERE `forum`.`forumid` =100 LIMIT 1 ;

how can i run that for all forums instead of just #100

any ideas? thanks

Guest190829
02-23-2008, 11:42 PM
Remove the WHERE and LIMIT clause.

reesev
02-23-2008, 11:58 PM
thanks alot!!!!