Hi Clever Peeps,

I wondered if someone might be able to assist me.

We have 1000s of K2 items, where the Extra Field data needs to be modified and I am struggling to be able to create a working query to update them, so wondered if someone could offer some guidance.

In my XXX_k2_items table, there is the extra_fields column.
This is currently populated with data such as:

I would like to run a query that updates XXX_k2_items and changes any extra_field column that contains "WIDGET" and change it to "WOGGLE".

I think I have confused myself too much :silly:

Many thanks in advance.

Hi. There are two ways to do this:

1. Write a PHP script which will load one by one the items and update them.
2. Use an SQL query. This is simpler but it will replace all instances of the "WIDGET" word in your extra fields column. The query will look like:

Remember to backup your site first since this may affect other extra fields also.

Hey Lefteris,

Wow, is it as simple as that . . . .
OK, time to back up a db and play.

I will be back with an update.

Hey Lefteris,

A big thank you!!!!

Yes that all works lovely and will save me a lot of item editing.

Thank you very much.

You are welcome.