Skip to content

Commit 0af69ed

Browse files
tpom-kuhn
authored andcommittedJun 3, 2015
Add pertinent example for 'LIKE' operator
The usage examples for the 'LIKE' operator are not really pertinent. The proposed change adds an example that actually illustrates the usual usage of the 'LIKE' operator.
1 parent 6a019ad commit 0af69ed

File tree

2 files changed

+6
-0
lines changed

2 files changed

+6
-0
lines changed
 

‎resources/function_help/ILIKE

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -11,3 +11,7 @@ None
1111
<pre> 'A' ILIKE 'A' &rarr; returns 1 </pre>
1212
<pre> 'A' ILIKE 'a' &rarr; returns 1 </pre>
1313
<pre> 'A' ILIKE 'B' &rarr; returns 0 </pre>
14+
<pre> 'ABC' ILIKE 'b' &rarr; returns 0 </pre>
15+
<pre> 'ABC' ILIKE 'B' &rarr; returns 0 </pre>
16+
<pre> 'ABC' ILIKE '%b%' &rarr; returns 1 </pre>
17+
<pre> 'ABC' ILIKE '%B%' &rarr; returns 1 </pre>

‎resources/function_help/LIKE

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -11,3 +11,5 @@ None
1111
<pre> 'A' LIKE 'A' &rarr; returns 1 </pre>
1212
<pre> 'A' LIKE 'a' &rarr; returns 0 </pre>
1313
<pre> 'A' LIKE 'B' &rarr; returns 0 </pre>
14+
<pre> 'ABC' LIKE 'B' &rarr; returns 0 </pre>
15+
<pre> 'ABC' LIKE '%B%' &rarr; returns 1 </pre>

0 commit comments

Comments
 (0)
Please sign in to comment.