Goaskle.com Help Desk
Goaskle.com Support Department Goaskle.com Help Desk Knowledgebase Web hosting Database MySQL
How to replace text in field using mysql request?
Suggested knowledgebase articles:

How to replace text in field using mysql request?

UPDATE table_name SET field = REPLACE(field, 'foo', 'bar') WHERE INSTR(field, 'foo') > 0;

example:

UPDATE `catalog_product_entity_text` SET value = REPLACE(value, 'Textold', 'Text new') WHERE INSTR(value, 'Textold') > 0;
Was this article helpful? Yes | No

Article Details

Article ID:
84
Category:
MySQL
Date added:
22.07.2022 10:01:07
Views:
122
Rating (Votes):
(0)
Go back

Related articles

  • How to add the uploaded files to the media library of wordpress when a form submission happens using the gravity forms plugin?
  • CSS for customize Gravity Forms template for Wordpress
  • How to Install and setup Wordpress plugin: QR Code Tag for WC order emails, POS receipt emails, PDF invoices, PDF packing slips, Blog posts, Custom post types and Pages (from goaskle.com)?
  • How to fix issue in mysql import CREATE ALGORITHM=UNDEFINED DEFINER=?
  • How to fix -- ERROR 1227 (42000) at line 728: Access denied; you need (at least one of) the SUPER privilege(s) for this operation -- ?
  • How to make fresh version of update folder in magento 2 root using composer?

Powered by Help Desk Software HESK
More IT firepower? Try SysAid