I'm having terrible luck making a search engine for my site.
Right now i'm using match against for it but it doesn't find eveything
in fulltext i have artist and title and this is the query
select * from lyrics where match(artist,title) against('always');
which shows 0 results but if i just do where title like 'always' it shows 19.
select * from lyrics where match(artist,title) against('system down');
this query shows all artists and titles that have those words in it and words which works but then this one doesn't... i really know why and it's only titles it does this to not artists and both are in the same fulltext.
any ideas?
thank you
