Suppose I have two arrays. One looking like (3, 9, 10, 39), and one looking like (4, 10, 9, 48, 391, 2).
How would I (through pure MySQL) check if one of the elements in the first array is inside the other array?
Edit By checking, I mean returning true if one item of the first array is occuring in the second array.
Example:
SELECT IsElementFromFirstArrayInAnotherArray(array1, array2) AS isInArray
(1,2,3,4,2)etc. – Mathias Lykkegaard Lorenzen Mar 20 '13 at 8:23