Creating REGEXP patterns with use of subquery

Is there any way to build a REGEXP pattern set by using a subquery? I have a set of rows in table table, with the column value being target for my query. That column's content is a bracket separated list of values, like this: [118][Word][Integer][Stuff]... [67][Another word][Another

Re: Creating REGEXP patterns with use of subquery

Hello. This looks like a task for prepared statements. You can dynamically form the string from the query using GROUP_CONCAT, assign the created string to the variable. Then just prepare a right statement and invoke it using that variable. See: http://dev.mysql.com/doc/refman/5.0/en/sqlps.html

Re: Creating REGEXP patterns with use of subquery

Kim Christensen wrote: Is there any way to build a REGEXP pattern set by using a subquery? I have a set of rows in table table, with the column value being target for my query. That column's content is a bracket separated list of values, like this: [118][Word][Integer][Stuff]... [67][Another