Hi,
I'm building an internal site search engine (currently at http://www.ldresources.com/new_site/search/index.php, and i just discovered (& am using) mysl's indexing feature.
What i'm a little unclear about is how MATCH handles multiple words -- as in SELECT * FROM document WHERE MATCH (title,content,author_lname,author_fname,content) AGAINST "ffoo bar".
it appears to be using an OR junction. My mysql is 3.23.51 -- is there any easy way to do AND?
Also, what about partial words?
thanks,
