pk operator "LIKE"
contoh:
1. DELETE FROM master_employee WHERE nip LIKE "1005%" OR nip LIKE "1006%"
(menghapus data yang berawalan 1005 dan 1006)
2. DELETE FROM master_employee WHERE nip LIKE "%1005" OR nip LIKE "%1006"
(menghapus data yang berakhiran 1005 dan 1006)
3. DELETE FROM master_employee WHERE nip LIKE "%1005%" OR nip LIKE "%1006%"
(menghapus data yang mengandung 1005 dan 1006)
harry hartono <[EMAIL PROTECTED]> wrote:
temen2,
mohon bantuan. saya mau delete data yang nip nya mengandung 1005 dan 1006 di
table master_employee
contonya :
ls nip="1005 , 1006"
delete from master_employee
where nip in(:ls_nip);
tapi kok hasilnya data yang ada di master_employee terhapus semua
solusinya bagaimana ya?
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
