Using an "find and replace" chrome's app, I made some changes in the fulltext field of 300 joomla articles.

I could save each row one by one using the "go" button under each row (cf picture) but is there a way to save all the change (made in several rows) in once? I did try to use the "go" button at the bottom of the edit page but without success.

here is the query:

SELECT `fulltext` 
FROM kms_content
WHERE catid
IN ( 16, 17, 18, 19, 20, 21, 22 ) 
LIMIT 0 , 500

the editing option go button to save a single row go button at the bottom

1 Answer 1

UPDATE kms_content SET fulltext = REPLACE (fulltext, 'text to find', 'text to replace') WHERE catid IN (16, 17, 18, 19, 20, 21, 22);
  • thank you but I do need to replace some html character (such as ;" />) I'm afraid it won't work between the '...'
    – JinSnow
    Sep 2, 2014 at 14:31
  • It should work. Try it.
    – Farahmand
    Sep 2, 2014 at 14:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.