I have a content-type with a certain taxonomy term field that allows multiple values.
I don't need this field to be a taxonomy term field anymore, but just a simple text field. So, I want to "transform" the nature of the field.
I do know it is not possible and that I have to create a new text field and copy the values of my first field into my second through a custom php script.
But I hardly think that I'm going to need some help from you guys for the SQL query that will be a bit complex.
- I need to recover all the term's names for each piece of content
- and, if there are several of them, concatenate them with a comma (for example),
- and then copy the result in the new text field before deleting the old taxonomy field.
The truth is I have no idea how to proceed. Can I run the query directly in PhpMyAdmin? Or in a PHP file? Do I need to use a simple SQL query or an EntityFieldQuery class? I'm not very familiar with this kind of stuff.
Thanks in advance for any clue...