select records based on field content and replace that conte
Posted: Tue Jun 01, 2010 8:03 am
Hello,
I have a database table "table_name" with colomn "ID" (not the primary key).
I want to change the value for each field that has value "A" into value "B".
I thought I could achieve this with PHP statement
"update table_name set ID='B' WHERE ID='A'
but that does not work.
Can anyone help ?
Thanks in advance !
I have a database table "table_name" with colomn "ID" (not the primary key).
I want to change the value for each field that has value "A" into value "B".
I thought I could achieve this with PHP statement
"update table_name set ID='B' WHERE ID='A'
but that does not work.
Can anyone help ?
Thanks in advance !