regex « mysql « Java Database Q&A





1. REGEXP in MySQL Return unwanted value    stackoverflow.com

I have problem using REGEX in Mysql I have oid value in database like this

id -> value

1.3.6.1.4.1 -> Value a 1.3.6.1.4.1.2499.1.1.2.1.1.1.1.1 -> Value b 1.3.6.1.4.1.2499 ...

2. How to transform java regular expression to mysql regex    stackoverflow.com

I would like to push the regular expression evaluation down to a mysql database. Therefore I am looking for a way to transform a Java regular expression into a Mysql regular ...

3. EJBQL/MySQL Regexes and IN    stackoverflow.com

I have a list of Regexes and want to return those rows with a field which passes any regex. Is there anyway to something like the following:

SELECT * FROM Foo as ...

4. MySQL regular expression    stackoverflow.com

please suggest for a change in regular expression '^({0,1}{0,1}){0,1}[7-9][0-9]{0,1}{0,1}{0,1}[0-9]{1}[0-9]{7}$' to use with a MySQL statement.
This expression worked perfect using Java but failed using MySQL. This pattern is to match a 10 ...