ServiceNow Error when trying to use match regex, match pattern

Cannot for the life of me get these options to work in ServiceNow. No matter what string I try, I can't avoid this exception: Syntax Error or Access Rule Violation detected by database (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'MATCH_PAT '.b.*?' /* dev32225001, gs:1D04DB834F320300FFDBC4B18110C735, tx:ea11af' at line 1 Query is: SELECT count(*) AS recordcount FROM cmdb cmdb0 WHERE cmdb0.`sys_class_path` LIKE '/!!%' AND cmdb0.`name` MATCH_PAT '.b.*?' /* dev32225001, gs:1D04DB834F320300FFDBC4B18110C735, tx:ea11af8b4f320300ffdbc4b18110c7d4 */)

The other error indicates a usage of the function MATCH_RGX with the very same results. Can you please advise on how to use MATCH_RGX and MATCH_PAT?

Thank you, -Andy

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.