MYSQL string replace on column PHP

Question

Hi i want to do the equivalent of a string replace in php through mysql. My column has the string format "Release Date: Thursday 20th May 2012" I want to release the text release date:. I have tried this but with no avail

$query = ("UPDATE Films SET Film_Release = REPLACE(Film_Release, 'Release Date: ','"); 

$runquery = mysql_query($query);

Thanks guys

Maybe because of the typo's? Try this $query = "UPDATE Films SET Film_Release = REPLACE(Film_Release, 'Release Date: ','')"; — huysentruitw
– huysentruitw, Commented Apr 16, 2012 at 13:15
looks like you're missing apostrophe at the end where you're specifying the replacement string — Alexey Gerasimov
– Alexey Gerasimov, Commented Apr 16, 2012 at 13:15
what WouterH said. You're missing the second apostrophe of the replacement string and the closing bracket of the MySQL REPLACE function — cypherabe
– cypherabe, Commented Apr 16, 2012 at 13:20

Nicola Peluchetti · Accepted Answer · 2012-04-16 13:20:27Z

2

Try with an extra ' and with a closing )

$query = "UPDATE Films SET Film_Release = REPLACE(Film_Release, 'Release Date: ','')";

answered Apr 16, 2012 at 13:20

Nicola Peluchetti

77k32 gold badges150 silver badges197 bronze badges

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

1 Comment

huysentruitw Over a year ago

what a perfect copy/paste of my comment :)

Collectives™ on Stack Overflow

MYSQL string replace on column PHP

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related