@businesses = Business.find(:all, :conditions => ['name LIKE ?
or description LIKE ?',
"%#{params[:search]}%",
"%#{params[:search]}%"], :order => 'name')
i tried %?params% but no luck.
Right now it just finds apples instead of apples from applesauce
mysql search with ?
- Redlandspr
- Posts: 5
- Starts: 6
- Wiki Edits: 0
Hey where in a mysql search do i put ? so that apples in applesauce if found?
@businesses = Business.find(:all, :conditions => ['name LIKE ?
or description LIKE ?',
"%#{params[:search]}%",
"%#{params[:search]}%"], :order => 'name')
i tried %?params% but no luck.
Right now it just finds apples instead of apples from applesauce
@businesses = Business.find(:all, :conditions => ['name LIKE ?
or description LIKE ?',
"%#{params[:search]}%",
"%#{params[:search]}%"], :order => 'name')
i tried %?params% but no luck.
Right now it just finds apples instead of apples from applesauce
- William
- Posts: 1061
- Starts: 32
- Wiki Edits: 56
This one is a bit tricky - it needs to be:
@search = params[:search]
@businesses = Business.find(:all, :conditions => ['name LIKE ? or description LIKE ?', "%" + @search + "%","%" + @search + "%"], :order => 'name')
2008-07-22 12:17 AM
- Redlandspr
- Posts: 5
- Starts: 6
- Wiki Edits: 0
thanks William