Updating multiple rows

    Date: 02/08/07 (MySQL Communtiy)    Keywords: no keywords

    I need to update several rows. Each row has a date column with data like "2004-03-02". I want to change the year to 2007 for all the rows in my data base without changing the month and the day.

    Basically change a date like "2004-03-02" to "2007-03-02"

    Is there a way to do this do this all in one update query?

    Source: http://community.livejournal.com/mysql/109009.html

« probably an easy join || limiting data fetched »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home