Menu
SQL Server REPLACE() Function The REPLACE() function replaces all occurrences of a substring within a string, with a new substring. Note: The search is case-insensitive.
To replace, use the REPLACE() MySQL function. Since you need to update the table for this, use the UPDATE() function with the SET clause.
I have a table which has a few varchar fields named like this:
image_fullres | image_highres | image_mediumres | image_lowres | image_thumbnail
I currently have the same value for each of these fields(differing by row), so image_fullres has the same path as image_lowres and so on.
an example value for these paths would be http://mysite.com/images/image1.jpg
I would like to have each of these fields to contain a different and appropriate path name, so:
and so on...
Since all of my data is already in the database with duplicate paths by row, what SQL can I execute that would change the value of each field's data to an appropriate path?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With