Try the following queries:
'first name' ilike Mark 'first name' like r 'first name' like Mark or number = 3 number = 3 number == 3 not number == 3 not 'first name' ilike mark not ('first name' ilike mark or number = 2)
Number | First Name | Last Name | Username |
---|---|---|---|
1 | Mark | Otto | @mdo |
2 | Jacob | Thornton | @fat |
3 | Larry | the Bird | |
4 | Donald | McLuckie | @blue |
5 | Larry | Peterson | @frankie |
6 | Peter | Nielson | @green |
7 | John | Liu | @petie |
8 | Mark | Jackson | @stewie |
9 | Donald | McLuckie | @stewie |
10 | Mark | Jackson | @louie |
11 | Sue | Jackson | @frankie |
12 | Frank | Nielson | @louie |
13 | Peter | O'Connell | @blue |
14 | Mark | McLuckie | @stewie |
15 | Larry | Jackson | @bloe |
16 | Donald | Jackson | @blue |
17 | Larry | Liu | @bloe |
18 | John | Jackson | @blue |
19 | Larry | O'Connell | @green |
20 | Peter | Fujikawa | @green |
21 | Larry | McLuckie | @bloe |
22 | Mark | McLuckie | @green |
23 | Mark | O'Connell | @petie |
24 | Joe | Jackson | @petie |
25 | Sue | O'Connell | @stewie |
26 | Joe | O'Connell | @frankie |
27 | Larry | McLuckie | @blue |
28 | John | Peterson | @green |
29 | John | O'Connell | @petie |
30 | Larry | O'Connell | @petie |
31 | Mark | Jackson | @louie |
32 | Mark | Jackson | @frankie |
33 | Frank | O'Connell | @blue |
34 | Sue | O'Connell | @frankie |
35 | Larry | Fujikawa | @louie |
36 | Donald | O'Connell | @stewie |
37 | Peter | Fujikawa | @green |
38 | Larry | Jackson | @louie |
39 | John | O'Connell | @frankie |
40 | Larry | O'Connell | @green |
41 | Joe | Liu | @blue |
42 | Joe | Jackson | @bloe |
43 | Mark | O'Connell | @frankie |
44 | Peter | O'Connell | @blue |
45 | John | Fujikawa | @stewie |
46 | Sue | O'Connell | @stewie |
47 | Joe | Jackson | @green |
48 | Peter | Nielson | @bloe |
49 | John | Jackson | @stewie |
50 | Mark | Nielson | @stewie |
51 | Donald | Jackson | @stewie |
52 | Joe | Peterson | @petie |
53 | Joe | O'Connell | @frankie |
54 | Sue | Peterson | @blue |
55 | Donald | McLuckie | @bloe |
56 | Peter | Nielson | @blue |
57 | Larry | Liu | @petie |
58 | Sue | O'Connell | @louie |
59 | Frank | McLuckie | @stewie |
60 | John | Jackson | @louie |
61 | John | Fujikawa | @green |
62 | John | Fujikawa | @frankie |
63 | John | Liu | @bloe |
64 | Larry | Liu | @frankie |
65 | Sue | O'Connell | @frankie |
66 | Sue | Jackson | @blue |
67 | Larry | Liu | @bloe |
68 | Donald | Jackson | @louie |
69 | John | McLuckie | @blue |
70 | Larry | Fujikawa | @bloe |
71 | Mark | McLuckie | @green |
72 | John | Liu | @green |
73 | Larry | Liu | @green |
74 | Frank | Liu | @louie |
75 | John | O'Connell | @blue |
76 | Larry | Liu | @louie |
77 | Donald | Jackson | @stewie |
78 | Donald | Fujikawa | @louie |
79 | Frank | McLuckie | @green |
80 | Mark | Fujikawa | @louie |
81 | Donald | Fujikawa | @petie |
82 | Larry | Nielson | @blue |
83 | Frank | O'Connell | @louie |
84 | Peter | Fujikawa | @blue |
85 | Donald | Nielson | @louie |
86 | Donald | McLuckie | @blue |
87 | Sue | McLuckie | @blue |
88 | Frank | Jackson | @stewie |
89 | Larry | Jackson | @frankie |
90 | Sue | Jackson | @blue |
91 | Peter | Peterson | @frankie |
92 | Sue | Fujikawa | @louie |
93 | Sue | Jackson | @petie |
94 | Sue | Fujikawa | @green |
95 | Mark | Liu | @petie |
96 | Joe | Jackson | @bloe |
97 | Mark | McLuckie | @blue |
98 | Larry | Liu | @louie |
99 | Mark | Nielson | @blue |
100 | Larry | Nielson | @stewie |