Is it best practice to store semi-colon separated values in a database column like $beruflich and $internet?

It is not considered best practice to store semi-colon separated values in a database column as it violates database normalization principles and can make querying and manipulating the data more difficult. Instead, it is recommended to create a separate table to store the related values in a normalized structure, such as a many-to-many relationship table. 

// Example of creating a separate table for related values in a normalized structure

// Create a new table for storing related values
CREATE TABLE related_values (
    id INT PRIMARY KEY AUTO_INCREMENT,
    value VARCHAR(255),
    parent_id INT
);

// Insert related values into the new table
INSERT INTO related_values (value, parent_id) VALUES ('beruflich', 1);
INSERT INTO related_values (value, parent_id) VALUES ('internet', 1);

// Query the related values for a specific parent_id
SELECT value FROM related_values WHERE parent_id = 1;

Keywords

PHP database column semi-colon separated values data storage

Related Questions