[m_abdelfattah]

Now, I've MySQL field called `catgegory_ids`, if one row contains (1,5,23,45) . how can I make a search if any of these categories (1,5) are found ??

I thought of making the following:

PHP Code:

$category_ids = array(1,2,5,10);

foreach($category_ids AS $category_id) {

$query .= "OR `category_ids` LIKE `%" . $category_id , "%' ";

} 

But I feel it's stupid way !

[Nico]

PHP Code:

"... WHERE `category_ids` IN(" . implode(', ', $category_ids) . ")" 

[m_abdelfattah]

Originally Posted by Nico

PHP Code:

"... WHERE `category_ids` IN(" . implode(', ', $category_ids) . ")" 

now I add the value

Code:

1,2,3,4,56

to `category_ids` and here're the results

PHP Code:

SELECT * From `items` WHERE `category_ids` IN (1); 

Working.

PHP Code:

SELECT * From `items` WHERE `category_ids` IN (1); 

Not working

PHP Code:

SELECT * From `itmes` WHERE `category_ids` IN (56); 

Not working

[Jcbones]

Perhaps you should spell "items" right...

And your first and second query are the same, only one works but the other doesn't?

[m_abdelfattah]

Originally Posted by Jcbones

Perhaps you should spell "items" right...

And your first and second query are the same, only one works but the other doesn't?

BTW, the real table name is not items I just changed it here while writing the reply, so it's not a miss-spell !

and 2nd query which is not working , should be

Code:

SELECT * From `items` WHERE `category_ids` IN (1,2);

[Jcbones]

There is no reason those queries shouldn't work.

Have you put them into mysql console to see if it returns an error message?

[Nico]

I think the reason it doesn't work is:

Originally Posted by m_abdelfattah

if one row contains (1,5,23,45)

You're going to have to use regular expressions to have this work correctly. This isn't the best practice, though. You should use a third table to store the relations.

Anyway:

PHP Code:

"SELECT ... WHERE `category_ids` REGEXP '(^|,)(" . implode('|', $category_ids) . ")(,|$)'" 

(Untested, but should work)