SQLite: How do i search multiple values : I have two autocomplettextview and 3 columns in my table col1,col2,col3. col1 is primary key

table look like this:

    | col1 | col2   |  col3                 |
    -----------------------------------------
    | 1    | store1 |apple,pineapple,mango  |
    | 2    | store2 | apple,orange          |
    | 3    | store3 | apple,pineapple,orange|
    | 4    | store4 | orange,mango          |
    | 5    | store5 | mango,jackfruit       |

**I have two question:**

**Q1**: can i store multiple values in single column.If No then how can I store?

**Q2**: previously said i have two autocompletetextview to search 
**For Eg**:

If user types apple and pineapple in *two autocompletetextview* then i need to 

    *display row that matches these two texts.*

**Expected o/p**:

    | col1 | col2   |  col3                 |
    -----------------------------------------
    | 1    | store1 |apple,pineapple,mango  |
    | 2    | store3 | apple,pineapple,orange|
 how can I achieve this?
  
I gone through several reseaches, with the help of `foreign key` I can store multiple values in single column but How can i use *foreign key* in `Where clause` to achieve `expected o/p`.

Thanks in Advanced..
 


