MATCH vs LIKE

2002-01-15 Thread Peter Dunham
I am trying to speed up keyword searches using MATCH AGAINST instead of like, but am getting unexpected results. I had assumed that using 'WHERE MATCH fulltext(column.name) AGAINST 'searchterm' would produce the same results as 'WHERE column.name LIKE '%searchterm%' but it doesn't seem to.

Re: MATCH vs LIKE

2002-01-15 Thread Carsten Gehling
- Original Message - From: Peter Dunham [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 12:03 PM Subject: MATCH vs LIKE I am trying to speed up keyword searches using MATCH AGAINST instead of like, but am getting unexpected results. I had assumed