Keyword

Sql query on datebase for change category on items

  • Zeljka Kuhada
  • Zeljka Kuhada's Avatar Topic Author
  • Offline
  • New Member
More
10 years 1 month ago #131336 by Zeljka Kuhada
Hi,
I have 14000 items (articles) in wrong K2 category.
K2 don't have Batch funcionlity like Joomla
and only what in my mind to change value of category from category x in
to categry y in database

table: nnn_k2_items catid atribute

But I not familiar with sql language to write query

e.g. in table nnn_k2_items for all items with catid x change value to catid y

If any can halp with that.
Thanks

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


Powered by Kunena Forum