title: How do i design database and get data by Category in android
body: <p>For example data  if i categorize data to 3 group : Attraction, City landmark, Park</p>
  
  <pre><code>id      title           content          address           category
  
  1     GeneralPark     xxxxxxxxxxx      1234road         Park
  
  2     GreatMuseum      wwwwwwwwww       9877road         Attraction
  </code></pre>
  
  <p>Look at General Park. its category is Park. and it also in Attraction category. the question is .. how can i design database? Is it possible to  do like the following(put Park and Attraction in the same column):</p>
  
  <pre><code>id      title           content          address           category
  
  1     GeneralPark     xxxxxxxxxxx      1234road         Park,Attraction
  </code></pre>
  
  <p>So, if it's not, then how can i design database? and How should i implement this line to retrive data by category; i.e. By Attraction</p>
  
  <pre><code>public Cursor getplaces() 
  {
      Cursor c = mDb.query(Constants.TABLE_NAME_PLACE, null, null, null, null, null, null);
      return c;
  
  }
  </code></pre>
  
  <p>The expect result should show only Attraction Category:</p>
  
  <pre><code>id      title           content          address           category
  
  1     GeneralPark     xxxxxxxxxxx      1234road          Attraction
  
  2     GreatMuseum      wwwwwwwwww       9877road         Attraction
  
  4     Middlehigh-school ttttttttt       555road           Attraction
  
  5     ShoppingMall   ssssssssss        666road           Attraction
  </code></pre>
  
  <p>Thanks so much for your help. i'm quite new to developing. Thanks you</p>