i have two tables in my database one is A other one is B
A is having few fields in which three are id,name,group
B is having feilds like id,title,description, etc.

i have to search the id's of title and description that are having data similar to table A's name or group and then have to insert the id's in a field of table A.

For example,
if A is having 'Anna' in its name and 'girl' in its group then i have to search the title's and descriptions in table B that are containing this word 'Anna' or 'girl'.

I want to do this in one single query.

How can i do so?

Edit:
Iam explainng my tables here for a better understanding

```
 table A

id     name     group     matched_id
1       anna     girl
2       sydney   girl
3        max      boy                             etc.

Table B

id      title                                      description
1       A good girl                             Anna is a very good girl
2      Max doesnt work hard                    Boys are always like that only

```

etc...

see i will first search for a match for 'anna' in the table B's title and description and if a match is found in either of them then i'll store that id in table A only in the field 'matched id'
I'll do the same procedure for 'girl' and then for 'sydney' and so on