SQL query with regular expression

Question

I have a field in a table that contains 1,2,3, what I need is a way to check this field for a match with something like:

SELECT
  t1.something
FROM
  tblContent t1
WHERE
  1 IN (SELECT comma_delimited_string FROM tblAnother WHERE match=t1.ref)

Where 1 in the above query is the data I want to match in the 'comma_delimited_string' returned by the sub query.

This doesn't work and only returns a match if 1 is the first item in the subquery.

I've been reading about regular expressions, but have never used regular expressions in SQL.

If the comma_delimited_string contains 11,2,3 and not 1 then a match should not be returned, it should only match if the comma_delimited_string contains 1 or 1, or ,1

Should split up the values in another table.

Rick James
– Rick James

2016-01-07 02:52:43 +00:00
Commented Jan 7, 2016 at 2:52 — Rick James
– Rick James, Commented Jan 7, 2016 at 2:52

SPlatten · Accepted Answer · 2016-01-06 18:24:07Z

1

Solved by using:

    SELECT
      t1.something
    FROM
      tblContent t1
    WHERE
      FIND_IN_SET(1, (SELECT comma_delimited_string FROM tblAnother WHERE match=t1.ref))

answered Jan 6, 2016 at 18:24

SPlatten

5,85713 gold badges79 silver badges140 bronze badges

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

Collectives™ on Stack Overflow

SQL query with regular expression

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related