Does anyone know how to search MySQL database tables with rows that have multiple variables ... in database X say row "letters" contains "a,c,d,e" for "id=1" and "d,c,g,h" for "id=2" and I want to select for id's that have d and h.
<P>how do i do that?
<p>Something like this doesn't work ...
Select * from X where letters=d,h;
<p>Even something like this doesn't work for selecting out a single element ...
Select * from X where letters=d; <p>
Any ideas.
<P>how do i do that?
<p>Something like this doesn't work ...
Select * from X where letters=d,h;
<p>Even something like this doesn't work for selecting out a single element ...
Select * from X where letters=d; <p>
Any ideas.