phpmyadmin how do you find > and replace?

[105547111]

Hi,

I got a table in SQL. I want to do like a search function, but find and replace

Edit Delete 2007-05-12 08:39:41 CPU_USAGE 9 NULL
Edit Delete 2007-05-12 08:39:41 MAINMEM_USAGE 373808 NULL

Here is a example of the data. In phpmyadmin, I select the table and search.

I click CPU_USEAGE and then > 20

It lists them all.

Surely you must be able to do a query, and do this:

If CPU_USEAGE > 20 then replace 10

Can someone please tell me a query command.

[Tanoro]

I don't think there is any single query that can update and replace a given value throughout a whole database. You'll likely need some type of PHP scripting for that.

[giulix]

update <TABLE_NAME> set CPU_USAGE = 10 where CPU_USAGE > 20;