Help Mysql flexi field

Hello, I had like a little boost in my database.
Let me explain a type of document I have several fields of type html text area.
In the settings I have filled the defaults and this works very well for new documents, however for those who have been imported Unfortunately this is still empty.
I want to know what is the only manipulation to populate a field in the database and especially what command to enter.

I have over 2000 items to update me so this command is really necessary.

You want to populate a field value for all items?

is this value the same for all items

you want to use a PHP script?
or
a DB query via phpmyadmin?

I want to populate some fields html for all items of one type only (fiche).
And i think a DB query it's best solution not ?

mmm :roll:

ggppdk wrote: 1. You want to populate a field value for all items?

2. is this value the same for all items

3. you want to use a PHP script OR a DB query via phpmyadmin?

1 no it's only for one type of item

2 yes is this value the same for all items

3 i think a db query is better but I'm not sure

Actually you will need a PHP script to insert this

i won't write some code for this at least without testing and currently i don't have time for this

your script will need
- to get ids of items that have a specific Content Type
- then check which items have no value for the given textarea field
- then loop through there item adding a value to them


Effectively you want a default value for existing items?

This is possible in text field and a couple of others,

i planned on adding it for a few other fields too will do this