How can I make my search more broad?
- by user1804952
I created this search mysql string and it is to literal or maybe un-literal?
If I search for Dave for example it will only find items like "Dave something" and not find Dave.
$queryArtist = mysql_query("SELECT * FROM artists WHERE artist LIKE '%$ArtistNameSearch%' ORDER BY artist ASC");
I know mysql_query is out dated and will change it to mysqli soon as I get this worked out. Stuck here.
An example of it no working is
Example of search
Could it be becasue the %20 space?
I got it figured out, but it still does NOT find one direction or other things even those exist.
here is what I have now
$queryArtist = mysql_query("SELECT * FROM artists WHERE match(artist) against('$SafeSearchTerm' in boolean mode)");
