Adding data to an existing entry using a special symbol?

Good time friends, help in the approximate solution of one algorithm for MySqli and PHP .

Need to record which has a field to add data fields using the special symbol |.

Ie add text using | ... the field type is text.
Example : Bob|Peter|Andrew, etc

Many thanks in advance!
March 19th 20 at 08:52
3 answers
March 19th 20 at 08:54
Solution
March 19th 20 at 08:56
Solution
If I understand correctly what you want
UPDATE baza SET fields = CONCAT(fields , ' | ', 'Andrew ')
March 19th 20 at 08:58
NO NEED

This monstrous mockery of a database and programmers who then have to work with it.
For Andrey it is necessary to have a separate tableassociated with the source,and write to it, normal insert

Find more questions by tags MySQL