SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Guru phantom007's Avatar
    Join Date
    May 2008
    Posts
    736
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Question MySQL: Fulltext v/s LIKE %keyword%

    Hi

    I was trying to learn what a Fulltext search is and was wondering:

    1) How is it different from the LIKE '%keyword%' operator?
    2) Why should I use a Fulltext search and not the LIKE operator or when to use what?

    Can someone please explain this to me?


    Many thanks in advance.

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,580
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    The link in your post answers both your questions.

  3. #3
    SitePoint Guru phantom007's Avatar
    Join Date
    May 2008
    Posts
    736
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Dan Grossman View Post
    The link in your post answers both your questions.
    Can you please quote me the line from that link that describes the difference between LIKE and full text search?


    Thanks

  4. #4
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,580
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by cancer10 View Post
    Can you please quote me the line from that link that describes the difference between LIKE and full text search?


    Thanks
    No, because pretty much every line on that page describes something wholly different than a LIKE search. Just read it, and the rest of the section on FULLTEXT. It's nothing like a substring search in a column which is all LIKE does.

  5. #5
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You also don't need to post your question in every single mysql forum that you can find as well.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •