Results 1 to 1 of 1

Thread: FULLTEXT index select problem - Repeated records

  1. #1
    Join Date
    Jan 2006
    Location
    Kafr Sakr, Egypt
    Posts
    3

    FULLTEXT index select problem - Repeated records

    There is a table has two fields as FULLTEXT index. When I perform select using MATCH it produces in sometimes multi repeated results for the same record. Why this is happned?

    The following are :

    Table Struture:
    PHP Code:
    CREATE TABLE `article` (
      `
    idint(5unsigned zerofill NOT NULL auto_increment,
      `
    typist_idvarchar(15collate utf8_unicode_ci NOT NULL,
      `
    author_namevarchar(40collate utf8_unicode_ci NOT NULL,
      `
    pub_datedatetime NOT NULL,
      `
    write_datedatetime NOT NULL,
      `
    titlevarchar(255collate utf8_unicode_ci NOT NULL,
      `
    contenttext collate utf8_unicode_ci NOT NULL,
      `
    activitytinyint(1NOT NULL default '0',
      `
    last_editorvarchar(15collate utf8_unicode_ci NOT NULL,
      `
    last_edit_datedatetime NOT NULL,
      
    PRIMARY KEY  (`id`),
      
    FULLTEXT KEY `title` (`title`,`content`)
    ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Table handles articles' AUTO_INCREMENT=16 
    The query used
    PHP Code:
    SELECT idpub_datetitlecontent FROM article WHERE MATCH(title,contentAGAINST('Some Search' IN BOOLEAN MODE) AND  activity 1 ORDER BY pub_date DESC 
    I forgot to mention that MySQL version is 4
    Last edited by said_fox; 06-14-2007 at 03:29 PM.
    Best Regards,
    Said Bakr

Posting Permissions

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