Hi I have a varchar field to search. There are 5k records.
I'm using: WHERE name LIKE '%outer banks%' It seems to be very slow. I was reading about full text searches. Maybe I could do something like: WHERE MATCH ('name') AGAINST ('outer banks') I'm looking for a quick way to search. Does anyone have any suggestions? Thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]