mySQL help please

[d-null]

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

[Bro Media - BANNED FOR LIFE]

limit 1 makes sure that it only updates 1 record

[d-null]

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)

[DaveKnell]

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

--Dave

[d-null]

thanks Dave, off to experiment

[donborno]

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

--Dave

Rather use

WHERE member_id BETWEEN 1 AND 612