<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DE link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US>Hello,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>with my few SQL experience I am not sure, if my approach is correct.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>I am having a table, where I want to add 8 options (columns). With these options I want to classify each record and want to let the user search for the wanted record with theses options.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Lets say I have the option “shape”, “size” and “color”. Usually each record can be classified distinct, e.g. with shape= round, size= big, color=red<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Now I have records where the classification color could be red OR blue and the same record should be found, if the user searches either for red OR for blue. My approach is because an option can only have one value in the DB, I create two options (columns): color1 and color2, so that I can assign to color1: red and to color2: blue. Now I could set up my sql (simplified):<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>SELECT * FROM table WHERE<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>fldShape = ShapeValue AND<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>fldSize = SizeValue AND<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>fldColor1 = ColorValue<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>OR<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>fldShape = ShapeValue AND<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>fldSize = SizeValue AND<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>fldColor2 = ColorValue<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>because I have actually 8 Options and more than one can have alternative classifying, I get pretty big WHERE clauses because of the OR parts. Is this the only and state of the art approach, or are there more sophisticated ways to solve that?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Thanks for any recommendations<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Tiemo<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div></body></html>