SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot
    Join Date
    Dec 2006
    Posts
    120
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    about full text search

    Hi all, I'm new to full text search mode in mysql.

    Here are few simple question which i wish to know:

    1. Can I set all my text fields in the table to Full Text without caring whether they are use for searching purpose? Any bad effect to the page loading etc?

    2. When shall we use search like %...% and full text search? I read few articles from website, full text search seems is a better choice since it search faster.
    I need help

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,021
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    1. you can, yes, but there would be no point

    2. LIKE %...% is very, very slow
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Zealot
    Join Date
    Dec 2006
    Posts
    120
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    1. you can, yes, but there would be no point

    2. LIKE %...% is very, very slow
    Thank you for your sharing, r937..
    I need help


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
  •