How to add such a SQL query?

Question

MySQL

Hello.
There is this SQL query:

INSERT INTO db (name,f,link,time) VALUES ('%name%','%price%','%link%','%date%');

(name - PRIMARY KEY)
The task is this. Supplement the query in such a way that new data would be added to "f" and "time", not overwritten with new ones, but just added.
For example, the first request
is f=text1
time=15:58:00
The second
f=text2
time=15:59:00
The result
is f=text1|text2
time=15:58:00|15:59:00
Thank you!
ps: I know that date \ time do not accept this format. They have an attribute in my case VARCHAR.
And in general, you know that it’s not the best structure for storing data, but it’s necessary :(

Answer 1

Probably something like this:

INSERT INTO db (name, f, link, time) VALUES ('%name%', '%price%', '%link%', '%date%') 
ON DUPLICATE KEY UPDATE f = CONCAT_WS('|', f, '%price%'),  time = CONCAT_WS('|', time, '%date%')

Answer 2

kevus ,
how is it?

INSERT INTO db (name,f,link,time) VALUES ('%name%','%price%','%link%','%date%') 
    ON DUPLICATE KEY UPDATE f=CONCAT_WS('|', f, '%price%');