WmZilla - Webmaster and Marketplace

The Next Generation Webmaster and Trade Forum

I have a question about replacing in an SQL query!

RevvyBoi

New member

0

0%

Status

Offline

Posts

48

Likes

0

Rep

0

Bits

250

3

Months of Service

0%
Hello, I only want the specified data to change in the selected field, meaning only the data that is currently 52 should be changed to 102. When I use the query below, it affects results containing "52" and changes them to "102" including in "2527." I do not want this. Only values where "52" is written in meta_value should be changed to 102. The query I am using is: UPDATE wp_postmeta SET meta_value= replace(meta_value,'52','102'); I would appreciate it if you could provide the correct query. Thank you.
 

249

6,622

6,642

Top