#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    3
    Rep Power
    0
    Hi:

    I have a table in mysql with 20 columns and 1 million records.

    Now I want to search by keyword. Is IN better or LIKE ?

    What other points should i keep in mind ??

    Thanks!
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15

    you should use "LIKE".then only you get correct search result.

    ------------------
    SR -
    shiju.dreamcenter.net

    "The fear of the LORD is the beginning of knowledge..."

Similar Threads

  1. Replies: 3
    Last Post: July 10th, 2003, 07:47 PM
  2. The MySQL Grant Tables
    By guest in forum Development Articles
    Replies: 37
    Last Post: May 29th, 2003, 10:02 AM
  3. Upgrading tables in 'mysql' database
    By Bjarte in forum MySQL Help
    Replies: 3
    Last Post: January 2nd, 2002, 05:36 AM
  4. How fast is MySQL with large tables?
    By mohamed in forum MySQL Help
    Replies: 3
    Last Post: September 16th, 2000, 10:30 AM
  5. searching large tables with mySQL
    By tim2000 in forum MySQL Help
    Replies: 0
    Last Post: May 30th, 2000, 02:22 PM

IMN logo majestic logo threadwatch logo seochat tools logo