Home / server / Questions / 100228
Accepted
matt wilkie
Asked: 2010-01-07 13:47:23 +0800 CST

mysql: how may one change the value of certain records?

  • 772

For example with the following query I can select all the records I want to change, but then how do do the change? e.g. change all occurences of "seven" to "four"?

SELECT * FROM `templates` WHERE `attrib_B` LIKE `seven`

This is how I think of it in pseudo code:

if `attrib_B` like `seven`:
    set `attrib_B` = `four`

Thanks.

mysql

3 Answers

  1. Best Answer
    UPDATE `templates` set `attrib_b` = 'four' WHERE `attrib_B` like 'seven';
    • 1

  2. [for myPHPAdmin as per original question verbiage]

    You can use either the table editor to change the data rows manually (via web interface) or run a SQL UPDATE statement.

    Manually updating via web interface:

    1. Click on your table in the menu on the left
    2. Click the Browse tab, which will display the data rows in an HTML table
    3. Click Edit on the row(s) you want to edit
    4. Change the values in the Edit form

    Running a SQL UPDATE statement (faster as you can do them all at once):

    1. Click on your table in the menu on the left
    2. Click the SQL tab, which will give you a textbox you can enter a SQL statement into

    3. Use this SQL statement to update all the rows:

      UPDATE 'templates' SET 'attrib_B'='four' WHERE 'attrib_B' LIKE 'seven'

    4. Click the GO button to execute the statement

    • 0

  3. The question has already been answered, so I won't redo that but thought it might be handy to pass on a little tip for the future. It's helped me avoid excessive page turning of the manual many times.

    An easy way to search the MySQL documentation is to use the URL http://dev.mysql.com/doc/, followed by your search term. e.g.

    http://dev.mysql.com/doc/insert ignore

    will search the online documentation for "insert ignore".

    • 0