2

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

3
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 '14 at 14:31
  • It should work. Try it. – Farahmand Sep 2 '14 at 14:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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