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 |