Database query help...

[Xildjian]

Does anyone know how to make this type of query?

Say I have a table define as follows:

col1 col2 col3 col4
.......................................
tag | item1 | item2 | item3

I want to query the table with val1, val2, val3, but I don't care which column (2-4) val1 val2 or val3 is located in. Just as long as all the values live in that row.

I would appreciate any help, thanks!
_________________
Member Shadow of Iniquity development team

[teleri]

to learn how to use MySQL I would reccomend the book "MySQL Weekend Crash course" ISBN Number 0-7645-3634-6 not an advanced boot but for $20 american it is one of the best books for learing what you need in MySql.

[dms]

I guess there's always more than one way of doing things... how about

select MyColumn from MyTable where Field('item1',col2,col3,col4) > 0 and Field('item2',col2,col3,col4) > 0 and Field('item3',col2,col3,col4) > 0;

That will return any row which contains item1, item2 and item3 and where they are stored is irrelevent.

[Xildjian]