Sara wrote: > Using this query in my Perl Script to find the Category title from the > database given as: > C_and_C++/Forums > C_and_C++/Codes > C_and_C++/Sites > etc. > my $sql = qq(SELECT CAT_TITLE, FROM categories WHERE CAT_TITLE REGEXP > '^C_and_C\\+\\+/[a-zA-Z|_]+\$' ) > > $query = $dbh -> prepare ($sql) or die "Couldn't prepare statement: " > . $dbh->errstr; > > $query->execute(); > > And when the query is executed, I am gettin' error: > "DBD::mysql::st execute failed: Got error 'repetition-operator operand > invalid' from regexp" > I am using double \\ in front of + as advised on the link given below > but still gettin' error, any solution to it? > > http://213.136.52.42/bug.php?id=399 > See Clarkson's response on the grep. What bothers me is the WHERE clause, which seems to be lacking an equivalence or other matching condition. That is it equal to or LIKE (where the latter requires a wild card character is the databases I have used).
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
