How to escape double square brackets in a SQL query

Asked Feb 07 '20 at 19:38

Active Feb 07 '20 at 19:38

Viewed 248 times

The text i want to search is [[Help:

so this fails select * from tblWiktionaryPages where cl_Text_English like '%[[Help:%'

Because [ was a special character in SQL

So how do i escape [ and search?

I have tried below things and both failed

'%![![Help:%'

'%\[\[Help:%'

asked Feb 07 '20 at 19:38

MonsterMMORPG

1

Try escaping each bracket like this: `[[]` so your LIKE clause would be `like '%[[][[]Help:%'` – dvo Feb 07 '20 at 19:43
@dvo thanks that one works – MonsterMMORPG Feb 07 '20 at 19:44
@MonsterMMORPG glad to help. the answer JNevill noted says the same thing so I'd consider it a duplicate. – dvo Feb 07 '20 at 19:47

0 Answers0