mySQL help please
 

did this query:

UPDATE `BLOG_MEMBERS` SET `M_STAT` = '1' WHERE `BLOG_MEMBERS`.`MEMBER_ID` =612 LIMIT 1 ;

I am curious what the "limit 1" does?

I am curious how I would modify the syntax of the same query to automatically do all member_id from say 1 to 612?


thanks

limit 1 makes sure that it only updates 1 record

thanks

do I need to set up some kind of loop query to change all the records in one field?

(Im a newbie to the sql query thing)

Nope - just make your where clause something like
where member_id>=1 and member_id<=612

--Dave

:thumbsup thanks Dave, off to experiment

Rather use