mysql 匹配数字,MySQL正则表达式：如何用\d匹配字符串中的数字？

I have a column release_date which stores date in a string format(Not in DATETIME format. Because they can be sometime any other string literals).

I want to find all the records based on given month and year but with any date.

Tried following but did not work for me,

> Post.find(:all, :conditions => ["release_date RLIKE ? AND deleted_at is null", "^\d{2}-01-2016"])

When I try same thing with following by giving direct date, it works fine.

> Post.find(:all, :conditions => ["release_date RLIKE ? AND deleted_at is null", "09-01-2016"])

Note:- I am using Ruby On Rails 2 and MySQL

Your help is much appreciated!

解决方案

The \d is not supported by mysql/posix. Use a character class [0-9] and it should work. Alternatively you could use the posix character class for numbers [:digit:].