is there a simple way turn up a partial match?
ie,
"Select * from LISTINGS WHERE TITLE LIKE '%$a%'";
the field contains 'word'
a search for 'word' 'wor' 'wo' and 'w' turn up results, but a search for 'this word' does not...
thanks!
have a look here http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html see if that helps 😉