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.
SELECT IsElementFromFirstArrayInAnotherArray(array1, array2) AS isInArray