Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
SQL query
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)
Offline
Pages: 1