×
Kunena 5.1.5 Released - Security Release (Yesterday)

The Kunena team has announce the arrival of Kunena 5.1.5 [K 5.1.5] which is now available for download as a native Joomla extension for J! 3.8.x. This version addresses most of the issues that were discovered in K 5.1 and issues discovered during the development stages of K 5.1. This is a Security release.

× This is for users to help other users, to discuss topics that are related to forum administration in general or problems in running Joomla. This is not the place to ask for Joomla support. If you want assistance with Joomla please ask at forum.joomla.org

Question Need help with mysql query

More
6 years 5 months ago #1 by Baze
I'd appreciate if anyone here keen with mysql help me out.

i need to copy the data from the intro text into the full text in each article except those from one category (id=88)

Basically, I'm trying to copy all data from the "introtext" field into the "fulltext" in the table jos_content but without the contents from catid=88

i was trying with something like this:
UPDATE jos_content
SET `introtext` = `fulltext`, `fulltext` = ''
WHERE `introtext` = '';

but i don't know how to exclude the articles from catid=88 and how to copy and put the data from introtext in front of the fulltext..

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to add attachements.
  • Not Allowed: to edit your message.
Time to create page: 0.143 seconds