MySQL create view from concat value
- by cnotethegr8
Lets say I have a table as follows,
+----+-------------+
| id | value |
+----+-------------+
| 1 | aa,bb,cc,dd |
| 2 | ee,ff,gg,hh |
+----+-------------+
I want to be able to search this table to see if id = 1 AND value = 'cc'.
Im assuming a good way of doing this is to grab the id = 1 row and split its values into separate rows in a new…