mysql replace within phpmyadmin gives error

Question

In following sql query I get an error on replace row. What is wrong I do not get. Probably phpmyadmin does not work with ' single code. I also try ` does not work eather.

Does someone has a solution for this?

UPDATE   `wp_postsbck` 
SET `post_content` =  REPLACE(
'<p style="font-size: 17px; line-height: 27px; margin-top: 10px;">',
'<p>')
WHERE
`guid` = 'http://xxxx/?page_id=329'

Tryed this also:

UPDATE   `wp_postsbck` 
SET `post_content` =  REPLACE(
'<p style=\"font-size: 17px; line-height: 27px; margin-top: 10px;\">',
'<p>')
WHERE
`guid` = 'http://xxxx/?page_id=329'

Thanks

Oeps... I forgot a part! Sorry first part (field) not written.

REPLACE takes three arguments. You have only supplied two. See the MySQL reference here — user1864610
– user1864610, Commented Jul 17, 2015 at 8:18
So it should be SET post_content = REPLACE(post_content, '<p style="font-size: 17px; line-height: 27px; margin-top: 10px;">', '<p>') — Anthony
– Anthony, Commented Jul 17, 2015 at 8:39

Alepac · Accepted Answer · 2015-07-17 08:37:33Z

1

As seen in manual the right syntax of the REPLACE function is:

REPLACE(str,from_str,to_str)

so you need to provide 3 arguments to the function

answered Jul 17, 2015 at 8:37

Alepac

1,84313 silver badges24 bronze badges

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

Comments

moliets · Accepted Answer · 2015-07-17 08:41:48Z

0

Thanks guys. I was blind! Complete forgotten the write 3 parts in statement. I will have a coffee break.

answered Jul 17, 2015 at 8:41

moliets

395 bronze badges

Collectives™ on Stack Overflow

mysql replace within phpmyadmin gives error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related