Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: Update MySQL (complex update)
03-07-2010, 05:34 PM #1
- Join Date
- Sep 2006
- Thanked 0 Times in 0 Posts
Update MySQL (complex update)
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:
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?Elliott