I want to create a table which contains a field with multiple values. I familiar with the "set" type, but the problem is that I don't know exactly all the value in advanced.
Does anyone know a solution?
Thanks
See Question&Answers more detail:osI want to create a table which contains a field with multiple values. I familiar with the "set" type, but the problem is that I don't know exactly all the value in advanced.
Does anyone know a solution?
Thanks
See Question&Answers more detail:osYou can put them as comma-separated values (strings) in the column, and use the find_in_set
function to query (in case you want to).
ADD:
You could later query as shown below:
For instance, to search for all rows which have value1
as a value in that column, use this:
SELECT T1.column
FROM Table T1
WHERE find_in_set('value1', T1.column) > 0;