Kunena 6.3.0 released

The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3

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
11 years 11 months ago #1 by Baze
Need help with mysql query was created 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:
Code:
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.

Time to create page: 0.489 seconds