Db mizden kullanılmayan +5 dan sonraki Küpe KOlye Yüzük ve belt leri silelim.
KOdu Kendi DB'mde denedim bir sorun yaşamadım Gönül Rahatlığıyla Kullanabilirsiniz.
Kod:
delete from item where strname like '%Ring (+6)%'
delete from item where strname like '%Ring (+7)%'
delete from item where strname like '%Ring (+8)%'
delete from item where strname like '%Ring (+9)%'
delete from item where strname like '%Ring (+10)%'
delete from item where strname like '%Pendant (+6)%'
delete from item where strname like '%Pendant (+7)%'
delete from item where strname like '%Pendant (+8)%'
delete from item where strname like '%Pendant (+9)%'
delete from item where strname like '%Pendant (+10)%'
delete from item where strname like '%Belt (+6)%'
delete from item where strname like '%Belt (+7)%'
delete from item where strname like '%Belt (+8)%'
delete from item where strname like '%Belt (+9)%'
delete from item where strname like '%Belt (+10)%'
delete from item where strname like '%Earring (+6)%'
delete from item where strname like '%Earring (+7)%'
delete from item where strname like '%Earring (+8)%'
delete from item where strname like '%Earring (+9)%'
delete from item where strname like '%Earring (+10)%'
KOdu Kendi DB'mde denedim bir sorun yaşamadım Gönül Rahatlığıyla Kullanabilirsiniz.
Kod:
delete from item where strname like '%Ring (+6)%'
delete from item where strname like '%Ring (+7)%'
delete from item where strname like '%Ring (+8)%'
delete from item where strname like '%Ring (+9)%'
delete from item where strname like '%Ring (+10)%'
delete from item where strname like '%Pendant (+6)%'
delete from item where strname like '%Pendant (+7)%'
delete from item where strname like '%Pendant (+8)%'
delete from item where strname like '%Pendant (+9)%'
delete from item where strname like '%Pendant (+10)%'
delete from item where strname like '%Belt (+6)%'
delete from item where strname like '%Belt (+7)%'
delete from item where strname like '%Belt (+8)%'
delete from item where strname like '%Belt (+9)%'
delete from item where strname like '%Belt (+10)%'
delete from item where strname like '%Earring (+6)%'
delete from item where strname like '%Earring (+7)%'
delete from item where strname like '%Earring (+8)%'
delete from item where strname like '%Earring (+9)%'
delete from item where strname like '%Earring (+10)%'