This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I need to search for exact match of c++, so escaped it with backslash and used regexp wordboundries like this
SELECT * FROM tablename j where j.fieldname REGEXP '[[:<:]](C\\+\\+)[:>:]]' It is not displaying any result. But if i search with this syntax SELECT * FROM tablename j where j.fieldname REGEXP 'C\\+\\+' It displays all results other than exact match like VC++ which i dont need.
I guess problem with escape ++ and regexp exact match. Please suggest me a solution for this.