Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    New Coder
    Join Date
    Sep 2006
    Posts
    66
    Thanks
    6
    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:
    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?
    Attached Thumbnails Attached Thumbnails Update MySQL (complex update)-silhouettebrown_records.gif  


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •