Comma Delimited List REGEX in MySQL with Integer

Question

I can use the regex comparing a comma delimited list of GUID against a column that is a string, but I am having trouble doing it with an integer like the one below. Am I doing something wrong or is this not possible?

select * from sims_role where organization_id REGEXP '4929,4930'

Cameron · Accepted Answer · 2012-05-02 22:44:29Z

1

Perhaps you want:

select * from sims_role where organization_id REGEXP '^(4929|4930)$'

What you've used is identical to:

select * from sims_role where organization_id LIKE '%4929,4930%'

answered May 2, 2012 at 22:44

Cameron

99.4k29 gold badges206 silver badges233 bronze badges

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

1 Comment

Mike Flynn Over a year ago

Yep it was the pipe I was missing doh!

Collectives™ on Stack Overflow

Comma Delimited List REGEX in MySQL with Integer

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related