SEO | Link Popularity | Search Engine Consulting | SEO Tutorial | SEO Tools | SEO Forum
Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 06-25-2005, 02:39 PM
troth troth is offline
SEO Junior
 
Join Date: Jun 2005
Location: U.S.A
Posts: 2 troth is on a distinguished road
Search Mysql database with “LIKE” or “FULLTEXT”?

Hi,

I am working on the script that can search Mysql database.
To search Mysql database, I can use LIKE or FULLTEXT.
Could anyone tell me which one better? What is the major different?

Thanks!
__________________
Tony
gottatip
Reply With Quote
  #2  
Old 01-30-2006, 07:48 PM
ERE Breckenridge ERE Breckenridge is offline
SEO Junior
 
Join Date: Jan 2006
Posts: 18 ERE Breckenridge is on a distinguished road
fulltext and MATCH are faster than LIKE:

http://forums.mysql.com/read.php?24,18629,18629
__________________
Search all Breckenridge Colorado Real Estate including Ski Homes and Condos.
Reply With Quote
Reply


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


Login/Register
User Name
Password
Remember Me?

Forum Links
Forum Home
SEO Forum
Internet Marketing Forum
Web Design Forum
Web Hosting Forum
Programming Forum
SEO Chat

Quick Links
Forum Home
New Posts
Mark Forums Read
Open Buddy List
User Control Panel
Edit Avatar
Edit Profile
Edit Options
Miscellaneous
Subscribed Threads
My Profile

Search Forums

Advanced Search
All times are GMT -8. The time now is 05:57 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.