How can I replace the value when a specific string is found in SQL

Question

I run a wrong SQL query and now I have to fix some things from the beginning. In my wp_postmeta table there are two fields, meta_value and meta_key.

How can I replace the existing value of meta_key to _tdomf_custom_permalink on every row that the string http://www.domain.com/?h is found in meta_value using phpmyadmin SQL.

Secondly, how can I replace the http://www.domain.com/?h (in meta_value field) with another domain ?

Thank you.

Cyril Gandon · Accepted Answer · 2011-07-29 13:36:00Z

2

Just use update statements in SQL:

update wp_postmeta 
set meta_key = '_tdomf_custom_permalink' 
where meta_value = 'http://www.domain.com/?h'

to then replace the http://www.domain.com/?h:

update wp_postmeta 
set meta_value = 'http://www.yourdomain.com/?h' 
where meta_value = 'http://www.domain.com/?h'

edited Jul 29, 2011 at 13:36

Cyril Gandon

17.1k15 gold badges84 silver badges124 bronze badges

answered Jul 29, 2011 at 13:01

Don

727 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Don Over a year ago

have you tried not using % at the end of the searched string? Or if you are using %, did you change the query to use the LIKE keyword?

Collectives™ on Stack Overflow

How can I replace the value when a specific string is found in SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related