How to give relation to comma separated value and search on it.?
I have there tables
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?
Thanks in Advance.
I think it’s almost impossible, if possible at all. You must redesign your database, it does not complies with 1st normal form (read more here).
Records in event_tag table must look like:
event_id, tag_id must be in primary key, must be indexed and must have foreign keys to the ids in according tables.
Thanks for the reply. I have done it using custom functionality.