COUNT the same number and post how many there are

[seco]

So im trying to figure out how to count the same word in a field, for instance.

in the friend id's field.

21,73,125,9283,324432

and another entry friend id's field.

222,64645,125,5483,5467

Is there any way to have all the ids that match be counted and displayed with the total?

Thanks

[tomhath]

It would be easy if you created a separate table with a row for each id/friend_id combination. That would make inserting/deleting much easier as well.

Do you currently have them in an array, or just a string with the numbers concatenated together?

[Inkeye]

Well why not this:

(and there are probably errors in my syntax, but you get the idea):

SELECT * FROM table WHERE ($id LIKE '%,$srch,%') OR ($id LIKE '$srch,%') OR ($id LIKE '%,$srch')

Now you might be wondering why I didn't write it like this:

SELECT * FROM table WHERE ($id LIKE '%$srch%')

Because if you are looking for ID of 125, it will also find id's 1256 and 51259 and 5441250... etc. You have to look for it if it's the first number, or if it's in the middle, or if it's the last number.

-b