Hi all Facing the following problem
In a record there is a field category. Categories can be added/changed/removed If I would use a fieldtype of set if would have been destructive in case a category got removed. So I implemented by using a text type field and some extra validation routines. Can this be done more directly and more INSIDE mysql? Example data id type Page 1 category1,category2 Page 2 category3 Page 3 category2,category4 I currenlty do my selects with SELECT `id` FROM `thetable` WHERE `type` LIKE '%category3%'; But I suspect speed and other penalties may arrise when the database is really in production. -- Registered Linux User Number 379093 -- Feel free to check out these few php utilities that I released under the GPL2 and that are meant for use with a php cli binary: http://www.vlaamse-kern.com/sas/ --
pgpiItsZWIUvi.pgp
Description: PGP signature
