Hi http://www.mysql.com/doc/en/Fulltext_Search.html
the create and insert of data went ok but when i do SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database'); i get SQL-query I am using RH8.0 and mysql 3.23.56 and php 4.3.2 I connect ok and my other code works SELECT term, explanation FROM Glossary ORDER BY term ASC What i am ultimately working to is a typical A to Z set of links to anchors. I have the code working to display the Terms and Explanations with anchor for each new letter but now i am trying to select from the terms based on A-Z. All letters will be displayed but some letters do not have terms will not have links. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]