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][Anothe
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
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 integer][
