I want to do the following:

```
INSERT INTO table1 (term1, term2, number) values ('A','B',10); 

```

however if values A and B are already present in `table1` **regardless** of their order, ie. the predicate

```
(term1='A' && term2='B') OR (`term1='B' && term2='A')

```

holds true, then I just want to update column number. Is there any way of doing that?