no_rkm_medis
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nm_pasien
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
no_ktp
varchar(20)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
jk
enum('L', 'P')
latin1_swedish_ci
= != IS NULL IS NOT NULL
L
P
tmp_lahir
varchar(15)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tgl_lahir
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nm_ibu
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
alamat
varchar(200)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
gol_darah
enum('A', 'B', 'O', 'AB', '-')
latin1_swedish_ci
= != IS NULL IS NOT NULL
A
B
O
AB
-
pekerjaan
varchar(60)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
stts_nikah
enum('BELUM MENIKAH', 'MENIKAH', 'JANDA', 'DUDHA', 'JOMBLO')
latin1_swedish_ci
= != IS NULL IS NOT NULL
BELUM MENIKAH
MENIKAH
JANDA
DUDHA
JOMBLO
agama
varchar(12)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tgl_daftar
date
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
no_tlp
varchar(40)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
umur
varchar(30)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
pnd
enum('TS', 'TK', 'SD', 'SMP', 'SMA', 'SLTA/SEDERAJAT', 'D1', 'D2', 'D3', 'D4', 'S1', 'S2', 'S3', '-')
latin1_swedish_ci
= != IS NULL IS NOT NULL
TS
TK
SD
SMP
SMA
SLTA/SEDERAJAT
D1
D2
D3
D4
S1
S2
S3
-
keluarga
enum('AYAH', 'IBU', 'ISTRI', 'SUAMI', 'SAUDARA', 'ANAK', 'DIRI SENDIRI', 'LAIN-LAIN')
latin1_swedish_ci
= != IS NULL IS NOT NULL
AYAH
IBU
ISTRI
SUAMI
SAUDARA
ANAK
DIRI SENDIRI
LAIN-LAIN
namakeluarga
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kd_pj
char(3)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - A04 - A04 A06 - A06 A07 - A07 A08 - A08 A09 - A09 A17 - A17 A19 - A19 A20 - A20 A22 - A22 A23 - A23 A24 - A24 A25 - A25 A26 - A26 A30 - A30 A32 - A32 A33 - A33 A36 - A36 A38 - A38 A42 - A42 A58 - A58 AKA - AKA B00 - B00 B1 - B1 BPJ - BPJ - - - A04 - A04 A06 - A06 A07 - A07 A08 - A08 A09 - A09 A17 - A17 A19 - A19 A20 - A20 A22 - A22 A23 - A23 A24 - A24 A25 - A25 A26 - A26 A30 - A30 A32 - A32 A33 - A33 A36 - A36 A38 - A38 A42 - A42 A58 - A58 AKA - AKA B00 - B00 B1 - B1 BPJ - BPJ
no_peserta
varchar(25)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kd_kel
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- 4 - - 1 BAJO - 1061 BANGUNSARI - 10 BANJARSARI - 25 BEDALI - 201 BELOPA - 1053 BELOPA 21212 - 1101010218 BELOPA UTARA - 1018 BODAK - 1407 BRUMAN - 962 CAMPURJO - 1101010289 CERABAK - 8 CIBINONG - 957 CIP - 1398 CISARANTEN ENDAH - 1101010225 CURUG - 935 DAYAH DABOH - 987 DAYEUHLUHUR - 1382 DEPOK 2 - 931 DUKUH - 3 GERUNG - 89 GUE GAJAH - 968 GUNUGNSARI - 43 GUWOSARI - 1441 IE MASEN ULEE KARENG - 980 JATI JAJAR - 963 JONTLAK - 1406 JOYOTAKAN - 1101010281 JURANG JALER - 1409 KALIDAWIR - 24 kalitidu - 900 KAMPUNG BARU - 1044 KARANGPUCUNG - 1204 KARANGREJA - 1250 KARANG TIMUR - 1101010279 KARTASURA - 11 KEBON SARI - 78 KEDUNGWARU - 1101010222 KELURAHAN - 202 KROGOWANAN - 203 KUTA ALAM - 982 L - 960 LAM DINGIN - 985 LAMPEUERUT - 1000 LAMTEUMEN TIMUR - 981 LEMBUAK - 50 LENENG - 1383 LOTENG - 76 LOTIM - 62 MADURA - 1423 MAJENANG - 1196 MAKASAR - 965 MAKMUR - 966 MANDALA - 1080 MANTANG - 1388 MATARAM - 46 MEKARJAYA - 919 MERTOYUDAN - 18 MIDANG - 80 MULYASARI - 1084 NGIPAK - 200 PADANGSARI - 1095 PAGUTAN - 30 PAHONJEAN - 1355 PAJANGAN - 902 PAMULANG TIMUR - 904 PANIMBANG - 1135 PARDASUKA - 1003 PASA GADANG - 1101010234 PENGADANG - 1392 PENUJAK - 1384 PERUMNAS WAY KANDIS - 1101010227 PEUNITI - 976 PRAPEN - 82 PRAYA - 99 PRINGSEW - 1007 PRINGSEWU - 1002 PULO KERTO - 1101010230 PUNGE BLANG CUT - 967 PUNIA - 86 QWQW - 9 REJASARI - 6 SAMBILAWANG - 204 SAWANGAN BARU - 908 SEKARSULI - 2 SELAPARANG - 32 SELING - 14 SEMPULANG - 1101010275 SIALANG GAUNG - 1101010235 SINDANGSARI - 1077 SUAK LAMATAN - 1101010214 TEMON - 15 TENGARI - 1394 TES - 1101010220 TUMBANG TALAKEN - 1101010288 TUNGGULREJO - 205 1 - - 2 - SEKARSULI 3 - DUKUH 4 - 6 - REJASARI 8 - CERABAK 9 - QWQW 10 - BANGUNSARI 11 - KARTASURA 14 - SELING 15 - TEMON 18 - MERTOYUDAN 24 - KALIDAWIR 25 - BANJARSARI 30 - PAGUTAN 32 - SELAPARANG 43 - GUNUGNSARI 46 - MATARAM 50 - LEMBUAK 62 - LOTIM 76 - LOTENG 78 - KEBON SARI 80 - MIDANG 82 - PRAPEN 86 - PUNIA 89 - GERUNG 99 - PRAYA 200 - NGIPAK 201 - BEDALI 202 - KELURAHAN 203 - KROGOWANAN 204 - SAMBILAWANG 205 - TUNGGULREJO 900 - kalitidu 902 - PAJANGAN 904 - PAMULANG TIMUR 908 - SAWANGAN BARU 919 - MEKARJAYA 931 - DEPOK 2 935 - CURUG 957 - CIBINONG 960 - L 962 - BRUMAN 963 - JATI JAJAR 965 - MAKASAR 966 - MAKMUR 967 - PUNGE BLANG CUT 968 - GUE GAJAH 976 - PEUNITI 980 - IE MASEN ULEE KARENG 981 - LAMTEUMEN TIMUR 982 - KUTA ALAM 985 - LAM DINGIN 987 - DAYAH DABOH 1000 - LAMPEUERUT 1002 - PRINGSEWU 1003 - PARDASUKA 1007 - PRINGSEW 1018 - BELOPA UTARA 1044 - KAMPUNG BARU 1053 - BELOPA 1061 - BAJO 1077 - SINDANGSARI 1080 - MANDALA 1084 - MULYASARI 1095 - PADANGSARI 1135 - PANIMBANG 1196 - MAJENANG 1204 - KARANGPUCUNG 1250 - KARANGREJA 1355 - PAHONJEAN 1382 - DAYEUHLUHUR 1383 - LENENG 1384 - PENUJAK 1388 - MANTANG 1392 - PENGADANG 1394 - TENGARI 1398 - CIP 1406 - JONTLAK 1407 - BODAK 1409 - JURANG JALER 1423 - MADURA 1441 - GUWOSARI 1101010214 - SUAK LAMATAN 1101010218 - BELOPA 21212 1101010220 - TES 1101010222 - KEDUNGWARU 1101010225 - CISARANTEN ENDAH 1101010227 - PERUMNAS WAY KANDIS 1101010230 - PULO KERTO 1101010234 - PASA GADANG 1101010235 - SIALANG GAUNG 1101010275 - SEMPULANG 1101010279 - KARANG TIMUR 1101010281 - JOYOTAKAN 1101010288 - TUMBANG TALAKEN 1101010289 - CAMPURJO
kd_kec
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kd_kab
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- 4 - - 1 - BANTUL - 385 - GROBOGAN - 321 - LAMPUNG TENGAH - 367 - MADIUN - 325 - PATI - 369 - PURWOREJO - 368 - SUMBAWA - 366 1 - 160 ACEH BESAR - 155 ASAS - 9 ASASAS - 448 BANDA ACEH - 154 BANTUL - 232 BANYUMAS - 6 BELOPA UTARA - 173 BOGOR - 142 BOGOR 1212 - 453 BOGORPERUM KOSTRAD - 143 BREBES - 238 BUMIAYU - 25 BUNGO - 194 CILACAP - 187 D - 144 DEPOK - 120 GERUNG - 80 GRESIK - 236 JAKARTA TIMUR - 152 JATENG - 147 Kab. Bandung - 265 KAB. LOMBOK TEBNGAH - 231 KAB. LOMBOK TENGAH - 227 KABUPATEN - 413 KABUPATEN ACEH SINGKIL - 455 KABUPATEN BANTUL - 387 KABUPATEN BINTAN - 392 KABUPATEN BOJONEGORO - 524 KABUPATEN DHARMASRAYA - 470 KABUPATEN GUNUNG KIDUL - 426 KABUPATEN GUNUNG MAS - 523 KABUPATEN KEBUMEN - 457 KABUPATEN LEBONG - 412 KABUPATEN MAGELANG - 401 KABUPATEN MALANG - 425 KABUPATEN PASER - 510 KABUPATEN PURWOREJO - 394 KABUPATEN SIMEULUE - 449 KARTASURA - 12 KLATEN - 2 KOTA BANDAR LAMPUNG - 462 KOTA BANDUNG - 460 KOTA JAKARTA TIMUR - 309 KOTA JAKARTA UTARA - 301 KOTA MADIUN - 358 KOTA MAGELANG - 18 KOTA PADANG - 469 KOTA PALEMBANG - 465 KOTA SURAKARTA - 516 KOTA TANGERANG - 514 KULONPROGO - 15 LAMPUNG SELATAN - 275 LB LINTAH - 235 LHOKSEUMAMWE - 158 LHOKSEUMAWE - 156 LOBAR - 39 LOMBOK BARAT - 48 LOMBOK TENGAH - 198 LOMBOK TENGAHG - 207 LOMBOK UTARA - 224 LOTENG - 74 LOTIM - 60 LUWU - 170 MADIUN - 11 MADURA - 212 MAGELANG - 153 MAGETAN - 3 MALANG - 197 MATARAM - 30 MUARA ENIM - 272 NTB - 32 PAMULANG - 93 PRAYA - 90 PRINGSEWU - 159 SAWANGAN - 97 SENGKOL - 225 SUKMAJAYA - 108 TES SAJA - 444 TULUNGAGUNG - 24 WONOGIRI - 8 WQWQW - 10 YOGYAKARTA - 91 1 - - 2 - KLATEN 3 - MAGETAN 4 - 6 - BANYUMAS 8 - WONOGIRI 9 - ASAS 10 - WQWQW 11 - MADIUN 12 - KARTASURA 15 - KULONPROGO 18 - KOTA MAGELANG 24 - TULUNGAGUNG 25 - BUMIAYU 30 - MATARAM 32 - NTB 39 - LOBAR 48 - LOMBOK BARAT 60 - LOTIM 74 - LOTENG 80 - GERUNG 90 - PRAYA 91 - YOGYAKARTA 93 - PAMULANG 97 - SAWANGAN 108 - SUKMAJAYA 120 - DEPOK 142 - BOGOR 143 - BOGORPERUM KOSTRAD 144 - D 147 - JATENG 152 - JAKARTA TIMUR 153 - MAGELANG 154 - BANDA ACEH 155 - ACEH BESAR 156 - LHOKSEUMAWE 158 - LHOKSEUMAMWE 159 - PRINGSEWU 160 - 1 170 - LUWU 173 - BELOPA UTARA 187 - CILACAP 194 - BUNGO 197 - MALANG 198 - LOMBOK TENGAH 207 - LOMBOK TENGAHG 212 - MADURA 224 - LOMBOK UTARA 225 - SENGKOL 227 - KAB. LOMBOK TENGAH 231 - KAB. LOMBOK TEBNGAH 232 - BANTUL 235 - LB LINTAH 236 - GRESIK 238 - BREBES 265 - Kab. Bandung 272 - MUARA ENIM 275 - LAMPUNG SELATAN 301 - KOTA JAKARTA UTARA 309 - KOTA JAKARTA TIMUR 321 - - GROBOGAN 325 - - MADIUN 358 - KOTA MADIUN 366 - - SUMBAWA 367 - - LAMPUNG TENGAH 368 - - PURWOREJO 369 - - PATI 385 - - BANTUL 387 - KABUPATEN BANTUL 392 - KABUPATEN BINTAN 394 - KABUPATEN PURWOREJO 401 - KABUPATEN MAGELANG 412 - KABUPATEN LEBONG 413 - KABUPATEN 425 - KABUPATEN MALANG 426 - KABUPATEN GUNUNG KIDUL 444 - TES SAJA 448 - ASASAS 449 - KABUPATEN SIMEULUE 453 - BOGOR 1212 455 - KABUPATEN ACEH SINGKIL 457 - KABUPATEN KEBUMEN 460 - KOTA BANDUNG 462 - KOTA BANDAR LAMPUNG 465 - KOTA PALEMBANG 469 - KOTA PADANG 470 - KABUPATEN DHARMASRAYA 510 - KABUPATEN PASER 514 - KOTA TANGERANG 516 - KOTA SURAKARTA 523 - KABUPATEN GUNUNG MAS 524 - KABUPATEN BOJONEGORO
pekerjaanpj
varchar(35)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
alamatpj
varchar(100)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kelurahanpj
varchar(60)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kecamatanpj
varchar(60)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kabupatenpj
varchar(60)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
perusahaan_pasien
varchar(8)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - - I0002 - I0002 - - - I0002 - I0002
suku_bangsa
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - 1 ARAB - 16 ASMAT - 18 BALI - 15 BUGIS - 9 DAYAK - 12 INGGRIS - 17 JAWA - 5 LOMBOK - 68 LUWU - 11 MADURA - 8 MELAYU - 13 PALEMBANG - 22 PAPUA - 37 SASAK - 3 SUNDA - 4 SUNDU BUHUN - 14 1 - - 3 - SASAK 4 - SUNDA 5 - JAWA 8 - MADURA 9 - BUGIS 11 - LUWU 12 - DAYAK 13 - MELAYU 14 - SUNDU BUHUN 15 - BALI 16 - ARAB 17 - INGGRIS 18 - ASMAT 22 - PALEMBANG 37 - PAPUA 68 - LOMBOK
bahasa_pasien
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - 1 BANJAR - 6 INDONESIA - 5 JAWA - 11 MADURA - 2 MELAYU - 7 NGAPAK - 3 PERANCIS - 30 SASAK - 10 SUNDA BUHUN - 9 SUNDA JAWA - 8 SUROBOYOAN - 4 1 - - 2 - MADURA 3 - NGAPAK 4 - SUROBOYOAN 5 - INDONESIA 6 - BANJAR 7 - MELAYU 8 - SUNDA JAWA 9 - SUNDA BUHUN 10 - SASAK 11 - JAWA 30 - PERANCIS
cacat_fisik
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - 1 Bisu - 3 Buta - 2 Lumpuh - 8 TIDAK ADA - 5 Tidak Punya Tangan Kanan - 4 Tuli - 58 1 - - 2 - Buta 3 - Bisu 4 - Tidak Punya Tangan Kanan 5 - TIDAK ADA 8 - Lumpuh 58 - Tuli
email
varchar(50)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
nip
varchar(30)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
kd_prop
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
- - 1 -NTB - 286 1 - 2 ACEH - 536 BANTEN - 601 BENGKULU - 496 BENGKULU 2121212 - 540 DI YOGYAKARTA - 469 DKI JAKARTA - 385 JATENG - 66 JAWA BARAT - 321 JAWA TENGAH - 3 JAWA TENGAHJL ANGGUR NO.36 RT - 207 JAWA TIMUR - 267 KALIMANTAN TENGAH - 610 KALIMANTAN TIMUR - 597 KEPULAUAN RIAU - 476 KURANJI - 320 LAMPUNG - 359 MADURA - 300 MALUKU - 312 NTB - 268 NUSA TENGGARA BARAT - 313 NUSA TENGGARA BARATT - 315 NUSA TENGGARA BARRATT - 316 PRAYA - 292 PROPINSI - 497 SDSDSDSD - 533 SUL-SEL - 13 SUL-SELBELOPA - 48 SUL-SELBELOPAJ - 264 SULSEL - 43 SUMATERA BARAT - 556 SUMATERA SELATAN - 355 YOGYAKARTA - 317 1 - - 2 - 1 3 - JAWA TENGAH 13 - SUL-SEL 43 - SULSEL 48 - SUL-SELBELOPA 66 - JATENG 207 - JAWA TENGAHJL ANGGUR NO.36 RT 264 - SUL-SELBELOPAJ 267 - JAWA TIMUR 268 - NTB 286 - -NTB 292 - PRAYA 300 - MADURA 312 - MALUKU 313 - NUSA TENGGARA BARAT 315 - NUSA TENGGARA BARATT 316 - NUSA TENGGARA BARRATT 317 - YOGYAKARTA 320 - KURANJI 321 - JAWA BARAT 355 - SUMATERA SELATAN 359 - LAMPUNG 385 - DKI JAKARTA 469 - DI YOGYAKARTA 476 - KEPULAUAN RIAU 496 - BENGKULU 497 - PROPINSI 533 - SDSDSDSD 536 - ACEH 540 - BENGKULU 2121212 556 - SUMATERA BARAT 597 - KALIMANTAN TIMUR 601 - BANTEN 610 - KALIMANTAN TENGAH
propinsipj
varchar(30)
latin1_swedish_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
