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]

Reply via email to