UPDATE `bib_en_yusuf` SET `status_lang` = 1 WHERE
`label` like '%islam%' or
`label` like '%arab relegion%' or
`label` like '%egypt%' or
`label` like '%cairo%' or
`label` like '%libya%' or
`label` like '%saud%' or
`label` like '%morrocco%' or
`label` like '%algeria%' or
`label` like '%tunis%' or
`label` like '%sudan%' or
`label` like '%somalia%' or
`label` like '%muritania%' OR
`label` like '%iraq%' or
`label` like '%iran%' or
`label` like '%palestine%' or
`label` like '%lebanon%' or
`label` like '%jordan%' or
`label` like '%yemen%' or
`label` like '%qatar%' or
`label` like '%bahrain%' or
`label` like '%oman%' or
`label` like '%emarate%' or
`label` like '%riyadh%' or
`label` like '%jeddah%' or
`label` like '%suez%' or
`label` like '%alexandria%' or
`label` like '%mekka%' or
`label` like '%mecca%' or
`label` like '%medina%' or
`label` like '%syria%' or
`label` like '%pakistan%' or

`label` like '%afghanistan%' or
`label` like '%profit%' or

`label` like '%khalif%' or
`label` like '%omar%' or

`label` like '%bakr%' or
`label` like '%osman%' or
`label` like '%turkey%' or
`label` like '%muslem%' or
`label` like '%faith%' or

`label` like '%allah%' or
`label` like '%quran%' or
`label` like '%hadith%' or
`label` like '%sharia%' or
`label` like '%tawhid%' or


`label` like '%sufi%' or
`label` like '%hajj%' or
`label` like '%hijab%' or
`label` like '%vail%' or
`label` like '%jerusalem%' or


`label` like '%aqsa%' or
`label` like '%mosque%' or
`label` like '%masjid%'



=========

upddate tragem form anther

UPDATE tragem s, quran_translate2 p SET s.`Eng_Arberry` = p.`Eng_Arberry`, s.`Eng_Asad` = p.`Eng_Asad`, s.`Eng_Daryabadi` = p.`Eng_Daryabadi`, s.`Eng_Hilali_And_Khan` = p.`Eng_Hilali_And_Khan`, s.`Eng_ClearQuran_God` = p.`Eng_ClearQuran_God`, s.`Eng_ClearQuran_Allah` = p.`Eng_ClearQuran_Allah`, s.`Eng_Community_God` = p.`Eng_Community_God`, s.`Eng_Community_Allah` = p.`Eng_Community_Allah`, s.`Eng_Khattab` = p.`Eng_Khattab`, s.`Eng_Maududi` = p.`Eng_Maududi`, s.`Eng_Mubarakpuri` = p.`Eng_Mubarakpuri`, s.`Eng_Pickthall` = p.`Eng_Pickthall`, s.`Eng_Qarai` = p.`Eng_Qarai`, s.`Eng_Qaribullah_And_Darwish` = p.`Eng_Qaribullah_And_Darwish`, s.`Eng_Sarwar` = p.`Eng_Sarwar`, s.`Eng_Yusuf_Ali` = p.`Eng_Yusuf_Ali` WHERE s.`QuranID` = p.`QuranID`