Re: Matching a string containing '+'

2006-02-08 Thread Greg Jetter
On Tuesday February 7 2006 9:52 pm, 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

Re: Matching a string containing '+'

2006-02-08 Thread Jay Savage
On 2/8/06, Herschel <[EMAIL PROTECTED]> wrote: > 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 R

Re: Matching a string containing '+'

2006-02-08 Thread Herschel
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 -> pr

RE: Matching a string containing '+'

2006-02-08 Thread Charles K. Clarkson
Sara wrote: [snip] : my $sql = qq( : SELECT CAT_TITLE, : FROM categories : WHERE CAT_TITLE REGEXP '^C_and_C\\+\\+/[a-zA-Z|_]+\$' : ); [snip] Why is there an escape character in front of the $ anchor? There isn't one in any of the examples in the linked content. Try this. It avoids