Hi, I need to find records from a table using multiple search words. On LIKE must and I want to. refrain from functional reasons My problem is that I search for a word fragments, these MATCH but can not find. In some cases everything works great but not always and I can not explain why! Here is an example: The database field has match text content: "mashed potatoes is 10 better for the skin than lime" subsequent searches tried I have, but I'm not . a result SELECT * FROM `artikel` WHERE MATCH (match test) AGAINST ('* ree *');