×
Blue Eagle 5 v1.6.2 has been Released for Kunena 5.2 (20 Jan 2021)

The Kunena team has announce the arrival of Kunena template Blue Eagle 5 v1.6.2 which is now available for download. This version addresses most of the issues that were discovered in development.

REQUIREMENTS
Blue Eagle 1.6.x requires Kunena 5.2.x to work with

× 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
8 years 9 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 edit your message.
Time to create page: 0.175 seconds