Anyone have a clue how I could go about trying to select a certain pattern of numbers with a
SELECT pattern FROM table WHERE pattern REGEXP '1_2+2_2+3_2+4_2&2016-06-09&1';
SELECT pattern FROM table WHERE pattern REGEXP '2_1&2016-06-09&1';
You don't need regex. Just use
% makes it not be anchored to the start of the string.
LIKE is not regex, but closer to a glob syntax. It may be faster than regex, too.