title: Rails how do I search in the first and second part of a string in the database?
body: <p>For my application I want to build a search form that gives back the name of the streets. But when I use <code>where('street like ?', 'wall')</code> it only returns: 'Wallstreet' and not for example: 'Second Wallstreet, The Wallstreet'</p>
  
  <p>I want to return also the 'Second Wallstreet, The Wallstreet' but not the a street name with 'Notwallstreet', where 'Wall' is somewhere in the middle.</p>
  
  <p>I have used the 'gem ransack' but there I only found the option contains. And that wil also return 'Notwallstreet'</p>