Urgent help Find Replace Query

HI,
Have use find and replace simple query before but for this need help

Table name - TM
field 1= title
field 2= cat
field 3= subcat

Want to find and replace all entries with subcat = 13 to 14 where field 1 title has keyword faucet and where field 2 cat = 18

Please help

 

UPDATE my_table
SET `field 3` = 14
WHERE
`field 1`LIKE '%faucet%'
AND `field 2`= 18
AND `field 3` = 13;

I would defintely do a backup first. Are the column names filed 1, filed 2 etc... or are they title, cat, subcat?

 

field names in table are tilte,cat etc !!! is above ok to do

 

You would change it to something like this then:

UPDATE my_table
SET subcat = 14
WHERE
title LIKE '%faucet%'
AND cat = 18
AND subcat = 13;

 

Thanks let me try the same in phpmyadmin sql query thanks again will let you progress