38 users online (0 members and 38 guests)  


  Results 1 to 3 of 3

Related

  1. Replies: 0
  2. The updating of back-links indexed by Google    Forum: Search Engine Optimization - SEO - Forum
    Replies: 2
  3. Status variables not updating?    Forum: PHP Forum
    Replies: 1
  4. FROM: field in form    Forum: Website Scripts Forum
    Replies: 4
  5. updating name servers    Forum: One Stop Domains Forum
    Replies: 17
  1. #1
    ramki067's Avatar
    New User

    Status
    Offline
    Join Date
    Oct 2007
    Posts
    22

    Updating a field, how.. Plz help.

    Hi,

    I have two tables "s" and "a", from which i need to append "Dolby" at the start of the "type" field in "a" table for all fields in table "s" having "Dolby" in location field of "s" table. How do i update the "a" table?

    I have written the update statement, but its not working...

    update a set type = concat('Dolby',type) where type="AC3" and location like '%Dolby%'' right join s on (s.sid=a.sid);


    Thanks,
    Ramki

  2. #2
    vanesavis's Avatar
    New User

    Status
    Offline
    Join Date
    Jul 2013
    Posts
    9

    Re: Updating a field, how.. Plz help.

    Then choose the updating option.

  3. #3
    jackdolphin's Avatar
    New User

    Status
    Offline
    Join Date
    Apr 2014
    Posts
    6

    Re: Updating a field, how.. Plz help.

    update a join s on on s.sid=a.sid set type = concat('Dolby',type) where type="AC3" and location like '%Dolby%'' ;