[[nom::Aaaa]] [[valide::1]]
[[nom::Bbbb]] [[valide::]]
[[nom::Cccc]] [[valide::1]]
[[nom::Dddd]] [[valide::0]]
[[nom::Eee]]
+ SELECT nom, valide FROM Query null values
= 5 rows 6 msec
| nom |
valide |
| Eee |
0 |
| Aaaa |
1 |
| Bbbb |
|
| Cccc |
1 |
| Dddd |
0 |
+ SELECT nom, valide FROM Query null values WHERE valide *
= 5 rows 6 msec
| nom |
valide |
| Eee |
0 |
| Aaaa |
1 |
| Bbbb |
|
| Cccc |
1 |
| Dddd |
0 |
+ SELECT nom, valide FROM Query null values WHERE valide 0
= 1 row 6 msec
+ SELECT nom, valide FROM Query null values
| WHERE valide 0
= 1 row 6 msec
+ SELECT nom, valide FROM Query null values
| WHERE valide !0
= 4 rows 6 msec
| nom |
valide |
| Eee |
0 |
| Aaaa |
1 |
| Cccc |
1 |
| Dddd |
0 |
+ SELECT nom, valide FROM Query null values
| WHERE valide = 0
= 3 rows 6 msec
| nom |
valide |
| Eee |
0 |
| Bbbb |
|
| Dddd |
0 |
+ SELECT nom, valide FROM Query null values
| WHERE valide != 0
= 2 rows 6 msec
+ SELECT nom, valide FROM Query null values
| WHERE valide == 0
= 2 rows 6 msec
+ SELECT nom, valide FROM Query null values
| WHERE valide !== 0
= 3 rows 6 msec
| nom |
valide |
| Aaaa |
1 |
| Bbbb |
|
| Cccc |
1 |
+ SELECT nom, valide FROM Query null values
| WHERE anyotherfield 0
= 5 rows 6 msec
| nom |
valide |
| Eee |
0 |
| Aaaa |
1 |
| Bbbb |
|
| Cccc |
1 |
| Dddd |
0 |
+ SELECT nom, valide FROM Query null values
| WHERE anyotherfield !0
= 0 rows 7 msec
- Bbbb
- 0 Eee
- 0 Dddd
- 1 Aaaa
- 1 Cccc