Query runner - how to escape characters
we are using a postgres back end on 7.3 , I have a sample query used in query runner which I can't get to work -
select pxTimeCreated, pyMessageKey from pegadata.hst_sometable_work and pyMessageKey LIKE '[ABC%'
the error i get is: ** Unclosed character class near index 6 '[FCC%' ^
I have tried using the character wild card i.e.
and pyMessageKey LIKE '_ABC%'
- but this returns no results.
The following works but can't use this due to performance reasons
and pyMessageKey LIKE '%ABC%'
so how do I escape the character '[' in a sql query execute in the query runner ??
(This is part of a query to assist in trouble shooting - so want to run the query via query runner - not a report of any kind )