Search query , multiple words ?

[eluser]Madmartigan1[/eluser]
Would it help to do this? It will work.

Code:

//turns 'my search' into '%my%search%'
$search=preg_replace('/\s\s++/','%',$search);//replace spaces with %
$search='%'.$search.'%';

$this->db->select('*')->from('quotes')->like('quote', $search , 'both')->where('approve',1)->limit($num, $offset);