Hi, Wondering if this can be done in SQL (db = mySQL v3.23) tbl_announcements
announcementID (primary key) groupID (list of foreign keys i.e. 1,3,5,12,14)
announcement I have put the groupID as a list, to save database space, as many
annoucements apply to many different groups. So Im on a page for group 4 how
do I select those records from a table where the groupID list contains 4?
SELECT * FROM tbl_annoucement WHERE groupID contains (4); I dont think that
mySQL supports 'contains'... my current work around is to pull the entire
table, then do a cfloop query, and only ...
Bookmarks