i probably have some misconceptions about full-text search but i was hoping that i'd be able to search for something like '*com* *tion*', i.e., find rows containing BOTH of the partial words like 'company duration', 'accompanying action', 'compositions'. yes, Virginia, full-text search is not partial-text search. except perhaps for single-word searches in boolean mode. in which case LIKE or INSTR will work just as well. or are there advantages in using boolean mode full-text instead of LIKE/INSTR for single-word partial searches?
thanks, --meg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]