help a newbie? mySQL find & replace

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 427,790 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,726 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 3837 | Replies: 15 | Solved

Previous Post in Thread

Next Post in Thread

•

Join Date: Aug 2006

Posts: 15

Reputation: kyleknapp is an unknown quantity at this point

Rep Power: 3

Solved Threads: 0

kyleknapp

Offline

Newbie Poster

help a newbie? mySQL find & replace

Oct 10th, 2006

I'm brand new to SQL queries, hoping someone can help me set up this query.

I'm using phpList to manage my mailing list. All user defined attributes appear to be stored in a table called phplist_user_user_attribute. The structure of this table is:

Field, Type
attributeid, int(11)
userid, int(11)
value, varchar(255)

attributeid 7 represents zipcodes
attributeid 16 refers to a boolean field referred to in another table as "Targeted", which I want to use for mailing list selections.

what I need to do is find every record with attributeid of 7 and a value of "68104" (for example), as:

Help with Code Tags

(Toggle Plain Text)

SELECT * FROM `phplist_user_user_attribute` WHERE `attributeid`= 7 AND `value`= "68104"

this gives me a list of all userid's in this zip code.
then, for every userid found, I need to set attribute 16 'ON', as

Help with Code Tags

(Toggle Plain Text)

UPDATE  `phplist_user_user_attribute`  SET  `value`  =  '' WHERE  `attributeid`  =16 AND  `userid`  =1;

(the above code sets the flag 'ON' for userid 1, but I can't figure out how to do it for every userid found in the previous query. Can I 'nest' these somehow?
I'm guessing this is pretty simple, I just need some help...

Thanks,
~kyle

Last edited by kyleknapp : Oct 10th, 2006 at 4:10 pm.