1 echo LIKE operator char datatype testing
;
3 Statement Executed
: Rows Affected
= 1
4 Statement Executed
: Rows Affected
= 1
5 Statement Executed
: Rows Affected
= 1
6 Statement Executed
: Rows Affected
= 1
7 Statement Executed
: Rows Affected
= 1
8 Statement Executed
: Rows Affected
= 1
9 Statement Executed
: Rows Affected
= 1
10 Statement Executed
: Rows Affected
= 1
11 Statement Executed
: Rows Affected
= 1
12 Statement Executed
: Rows Affected
= 1
13 Statement Executed
: Rows Affected
= 1
14 echo select * from t1
;
15 ---------------------------------------------------------
17 ---------------------------------------------------------
30 echo select * from t1 where f1 LIKE
'UPP%';
31 ---------------------------------------------------------
33 ---------------------------------------------------------
36 echo select * from t1 where f1 LIKE
'upp%';
37 ---------------------------------------------------------
39 ---------------------------------------------------------
44 echo select * from t1 where f1 LIKE
'upper%letter';
45 ---------------------------------------------------------
47 ---------------------------------------------------------
51 echo select * from t1 where f1 LIKE
'upper____letter';
52 ---------------------------------------------------------
54 ---------------------------------------------------------
57 echo select * from t1 where f1 like
'UP__R%SE';
58 ---------------------------------------------------------
60 ---------------------------------------------------------
63 echo select * from t1 where f1 like
'UP__R%SE' and f2
= 'B';
64 ---------------------------------------------------------
66 ---------------------------------------------------------
68 echo select * from t1 where f1 like
'UP__R%SE' and f2
= 'UPPER';
69 ---------------------------------------------------------
71 ---------------------------------------------------------
74 echo select * from t1 where f1 like
'UP__R%SE' and f2 like
'UPPER';
75 ---------------------------------------------------------
77 ---------------------------------------------------------