Man, if you need a full boolean search, ie more than one word, use fulltext !, it crunches cpu so you need a beasty machine, use like if its just one string you are searching for in a varchar field, use fulltext if you are searching in wads of text.
I highly recommend match against though, its the best thing that has come our way as yet dan (waiting for 4.1) > I'm building a financial-like web site (PHP - MySQL). I was requested > to build a search engine for IT. > > Everything works OK, w/ the exception of a certain component. The owner > of the web site will write, each day, a report for the customers. I use > TEXT fields to record each section of the report (there are 4 > sections). > > Now the search part: > 1. I can use LIKE %keyword% but when the DB will grow, I guess I will > get into trouble. > > 2. I can use MATCH - AGAINST, but the report it's quite stereotypical: > most of the words a user will look for are very common (the 50% rule). > > Any suggestion ? > > > -- > Cip > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
