Skip to content

Commit

Permalink
Browse files Browse the repository at this point in the history
Double espace backslash in help and add examples
  • Loading branch information
DelazJ committed Nov 26, 2021
1 parent ebcb7e3 commit 74a5e44
Showing 1 changed file with 4 additions and 2 deletions.
6 changes: 4 additions & 2 deletions resources/function_help/json/ILIKE
Expand Up @@ -5,7 +5,7 @@
"description": "Returns 1 if the first parameter matches case-insensitive the supplied pattern. LIKE can be used instead of ILIKE to make the match case-sensitive. Works with numbers also.",
"arguments": [
{"arg":"string/number","description":"string to search"},
{"arg":"pattern","description":"pattern to find, you can use '%' as a wildcard, '_' as a single char and '\\\\' to escape."}
{"arg":"pattern","description":"pattern to find, you can use '%' as a wildcard, '_' as a single char and '\\\\\\\\' to escape these special characters."}
],
"examples": [
{ "expression":"'A' ILIKE 'A'", "returns":"1"},
Expand All @@ -20,6 +20,8 @@
{ "expression":"'ABCD' ILIKE '_b%'", "returns":"1"},
{ "expression":"'ABCD' ILIKE '_B%'", "returns":"1"},
{ "expression":"'ABCD' ILIKE '%b%'", "returns":"1"},
{ "expression":"'ABCD' ILIKE '%B%'", "returns":"1"}
{ "expression":"'ABCD' ILIKE '%B%'", "returns":"1"},
{ "expression":"'ABCD%' ILIKE 'abcd\\\\\\\\%'", "returns":"1"},
{ "expression":"'ABCD' ILIKE '%B\\\\\\\\%'", "returns":"0"}
]
}

0 comments on commit 74a5e44

Please sign in to comment.