MySQL REGEXP - Select certain pattern of numbers and characters

Question

Anyone have a clue how I could go about trying to select a certain pattern of numbers with a 1 at the end?

Ex.

SELECT pattern FROM table WHERE pattern REGEXP '1_2+2_2+3_2+4_2&2016-06-09&1';

or

SELECT pattern FROM table WHERE pattern REGEXP '2_1&2016-06-09&1';

using the same number-underscore-number, ampersand, date, ampersand, number; just as long as that number 1 is at the end?

EDIT:

Actually, let me phrase it better. How do I use REGEXP to select an ampersand and the number 1 at the end of a string?

Laurel · Accepted Answer · 2016-06-15 00:35:47Z

3

You don't need regex. Just use LIKE:

LIKE '%&1'

The % 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.

answered Jun 15, 2016 at 0:35

Laurel

6,23114 gold badges35 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hamza Zafeer · Accepted Answer · 2016-06-15 01:00:09Z

1

SELECT column_name
FROM table 
WHERE column_name LIKE '%&1';

Note: You can also use LIKE operator for searching from start not only from end.

SELECT column_name
FROM table 
WHERE column_name LIKE '&1%';

answered Jun 15, 2016 at 1:00

Hamza Zafeer

2,45613 gold badges36 silver badges48 bronze badges