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.