By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | city | city LIKE 'b%n' | city LIKE BINARY 'b%n' | city RLIKE '^b.*n$' |
|---|---|---|---|---|
| 1 | boston | 1 | 1 | 1 |
| 2 | Boston | 1 | 0 | 1 |
| id | city | city LIKE 'b%n' | city LIKE BINARY 'b%n' | city RLIKE '^b.*n$' |
|---|---|---|---|---|
| 1 | boston | 1 | 1 | 1 |
| 2 | Boston | 1 | 0 | 1 |