Re: Multiple entries in 1 field
From: John Levine <johnl_at_taugh.com>
Date: Sun, 6 Oct 2019 16:50:38 -0000 (UTC)
Message-ID: <qnd60u$1s0s$2_at_gal.iecc.com>
Date: Sun, 6 Oct 2019 16:50:38 -0000 (UTC)
Message-ID: <qnd60u$1s0s$2_at_gal.iecc.com>
In article <4b13db92-5749-4aba-a27a-c843eac55fa5_at_googlegroups.com>,
<groovee_at_cyberdude.com> wrote:
>So, say I have a "stories" db, with fields such as storyid, storytext, dateposted, and category. Now under "category" I want it to
>have MULTIPLE CATEGORIES, ie. *one* story can be classified as "sci-fi" AS WELL AS "romance" AT THE SAME TIME!!
So long as you know in advance what the categories are, this sounds like exactly what the SET field type does.
Use FIND_IN_SET() to look things up.
-- Regards, John Levine, johnl_at_taugh.com, Primary Perpetrator of "The Internet for Dummies", Please consider the environment before reading this e-mail. https://jl.lyReceived on Sun Oct 06 2019 - 18:50:38 CEST