Hello friends,
How to give relation to comma separated value and search on it.?
I have there tables
[list=1]
[*]Event
[*]Event_Tag
[*]Tag
[/list]
Relation
Event has many tags
That tags are stroed in Event_Tag Table with comma separted values.
Problem is how to search for tag in Event Model?
Event_Tag Table
event_id tag_id
1 5,3,4,2
2 5,4,1
3 3
18 5,4,3,1
Tag Table
tag_id tag_name
1 Meeting
2 Conference
3 Diwali
4 Client
5 Annual
Thanks in Advance.