Dont know how to describe, i think the answer will be easy?

[ld0121]

Hi all,

$query = "select * from gzdata1 where ident like \"misc\" ORDER by rand() LIMIT 0, 5;";

What im doing here is pulling out random data from IDENT that is filtered using the an idenifying word MISC, what i need to do now is filter using more than one word, for example......

I know this code isnt right but it will show what im trying to do.....

$query = "select * from gzdata1 where ident like \"misc and search and chat etc etc\" ORDER by rand() LIMIT 0, 5;";

Any help would be great,

Thanks
Lee

[drawmack]

$query = "select * from gzdata1 where ident in (\"misc\",\"search\",\"chat\",\"etc\".\"etc\") ORDER by rand() LIMIT 0, 5;";

[ld0121]

Mystery solved, works great, thanks.

Lee