The downloadable version of this article is available here:
http://techrepublic.com.com/5138-9592-6050471.html
Have you used full-text searches in My SQL? What kind of results did you get? Was it more efficient or do you prefer SELECT queries?
Discussion on:
View:
Show:
my most common usage of mysql has been web apps, where select queries are the better option.
Full text search is really only usefull for completely internal operations, as the security risks with that specific a query running across the internet are way to high.
I use a combined method in a site search where the user is looking for a specific phrase in a particular area.
Full text search is really only usefull for completely internal operations, as the security risks with that specific a query running across the internet are way to high.
I use a combined method in a site search where the user is looking for a specific phrase in a particular area.
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
