Textpattern CMS support forum
I have to replace the whole <a> tag with an empty string, whatever the download URL is. Is this query correct? Thanks.
UPDATE textpattern SET Body_html = REPLACE(Body_html, '<a href="%">Download</a>', '')
Note: in case % wildcard cannot do the job, please consider that all URLs are of the same length.
Last edited by gilibaus (2020-04-05 11:01:42)