[Resolved] mysql query and array

Can you do something like this:

$query = "SELECT * FROM category WHERE 'in_array($number, CAT)'";

CAT is the field and contains comma delimited number like 1,2,3

obviously I would need a way to turn CAT into an array.

Is this possible?

What's the correct syntax?

No, for several reasons.

in_array($number, CAT) is valid PHP code, but only if CAT is a PHP constant.
in_array($number, CAT) is not valid SQL code, even though you want to try to pass it to the database as part of the query.
You are be trying to use a value discovered during the query "in" the query. Kind of like trying to use the results in the query itself, before the query even happens.

But you might try something like this:

$query = "SELECT * FROM category WHERE FIND_IN_SET($number, CAT) NOT IN (NULL, 0);

That's for MySQL. If you're using some other database, let me know.It's also just from memory, but should be valid for MySQL.

ok. How the heck does this work?

I created a colum with SET('1','2','3','4') type

Then I try and insert using:

INSERT INTO set_test SET set_check = '9,10,11,12';

It seems that the only way I can insert is with:

INSERT INTO set_test SET set_check = '1,2,3,4';

using the values I specified when creating the column type

Can I use text as my set? How to do? I have been looking at the MySQL manual all morning, and haven't gotten anywhere.