. . .

regexp

October 14, 2010

MySQL Regexp to match a number from comma separated list of numbers

I have found regexp select statements useful for databases which have fields of comma-separated numbers. If I need to select all rows with a given number in such a comma-separated list, a regular expression using word boundries would work:   [[:<:]] left word boundary [[:>:]] right word boundary   The […]