String multiple values in a single field separated by pipes |

I’m rebuilding a site in Wappler which was previously built in Wordpress. The data in Wordpress stores multiple options in single fields, eg.

Red
Blue
Green

are stored as

Red|Blue|Green

The would be a form containing checkboxes for each colour.

Can I keep this same structure? Or would I be better going through the data and using a many-to-many table instead? If I was started from scratch then I would use the many-to-many table option but because I’m running with the existing data, I need to decide the best approach.

If I can keep to the same piped data structure, is it easy to create the checkbox forms to add/update records?

Hope I’ve explained this clearly enough. Thanks in anticipation.