I have two tables name as "ALLKEYWORD" and "IllegalKeyword"

"ALLKEYWORD" table is like 

ID                  My_Keyword                     IsActive

1                       Sex Toy                            True

2                        Sussex                            True

3                        Sexgod                            True

4                        Sex God                           True

5                        Sexuality                         True

and "IllegalKeyword" table is like 

ID                       Keyword                

1                             Sex

Now I have to select and update "ALLKEYWORD" table those record  where 'Sex' keyword is appeared from  "IllegalKeyword" table..

In this case only 'Sex Toy' and 'Sex God'  is selected and updated from "ALLKEYWORD" table...

and "ALLKEYWORD" table can have 1.5 million records and  "IllegalKeyword" table can have 800 records...

Please help.....