...

View Full Version : Update MySQL (complex update)



erdubya
03-07-2010, 05:34 PM
I'm trying to update records in my music database that have a blank value in the 'website' field.

My music database fields are as follows:
songid
songtitle
album
artist
website

In the attached example (silhouettebrown_records.gif), several records for artist silhouette brown have blanks in the website field. I want to check all records for an artists (all artists, in this case silhouette brown) for a populated 'website' field and update all blank fields for that artist with that value. If there is no populated website field then leave all of them blank.

What is the most efficient way to accomplish this?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum