SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Wizard
    Join Date
    Mar 2002
    Location
    Bristol, UK
    Posts
    2,240
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Changing Multiple Rows

    Hi all,

    I have a MySQL database table containing information on roughly 125 movies.

    However, some of you that live in the UK may know about the BBFC's new '12a' classification effort. This is a problem for me as I need to now change any films with the '12' certificate to match this new certificate.

    Is there a query I can run which changes all rows containing '12' to '12a', without altering any other data?

    Thanks in advance

    -Sam
    Sam Hastings

  2. #2
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  3. #3
    SitePoint Wizard
    Join Date
    Mar 2002
    Location
    Bristol, UK
    Posts
    2,240
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi, thanks for the reply.

    It's blindingly obvious now, I previously thought UPDATE was just for changing all of the values in a row and not just one.

    Thanks!

    -Sam
    Sam Hastings


Bookmarks

Posting Permissions

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