How to change text custom fields to long text in one query.
Replies (1)
RE: How to change text custom fields to long text in one query.
-
Added by Michal Rysiak almost 4 years ago
It's actually much simpler. You can just update the custom_fields table, changing the field_format value from 'string' to 'text' for the custom field of your choice (selected by id in the example), like this:
update custom_fields set field_format='text' where id=<...>;
Tested and works great!