the Dead
پنج شنبه 08 آذر 1386, 19:06 عصر
بنده یک TABLE به این صورت دارم حالا میخواستم به صورت فول تکست روش سرچ کنم ولی خروجی Emptyset میده؟؟؟؟
CREATE TABLE IF NOT EXISTS cms_articles (
article_id int(11) NOT NULL auto_increment,
author_id int(11) NOT NULL default '0',
date_submitted nvarchar(20) NOT NULL default '0000-00-00 00:00:00',
title varchar(255) NOT NULL default '',
body mediumtext NOT NULL,
PRIMARY KEY (article_id),
KEY IdxArticle (author_id,date_submitted),
FULLTEXT KEY IdxText (title,body)
)ENGINE=MyISAM;
Query من
SELECT article_id FROM cms_articles WHERE MATCH (title,body) AGAINST('hello');
و
SELECT article_id FROM cms_articles WHERE MATCH (title,body) AGAINST('hello' IN BOOLEAN MODE);
هر دو رو امتحان کردم
و اطلاعات داخل جدول
+------------+-----------+---------------------+-------+---------------------+
| article_id | author_id | date_submitted | title | body |
+------------+-----------+---------------------+-------+---------------------+
| 2 | 1 | 2007-11-29 14:28:12 | hello | this is A idiot |
| 3 | 1 | 2007-11-29 14:34:33 | hello | dfssg |
+------------+-----------+---------------------+-------+---------------------+
CREATE TABLE IF NOT EXISTS cms_articles (
article_id int(11) NOT NULL auto_increment,
author_id int(11) NOT NULL default '0',
date_submitted nvarchar(20) NOT NULL default '0000-00-00 00:00:00',
title varchar(255) NOT NULL default '',
body mediumtext NOT NULL,
PRIMARY KEY (article_id),
KEY IdxArticle (author_id,date_submitted),
FULLTEXT KEY IdxText (title,body)
)ENGINE=MyISAM;
Query من
SELECT article_id FROM cms_articles WHERE MATCH (title,body) AGAINST('hello');
و
SELECT article_id FROM cms_articles WHERE MATCH (title,body) AGAINST('hello' IN BOOLEAN MODE);
هر دو رو امتحان کردم
و اطلاعات داخل جدول
+------------+-----------+---------------------+-------+---------------------+
| article_id | author_id | date_submitted | title | body |
+------------+-----------+---------------------+-------+---------------------+
| 2 | 1 | 2007-11-29 14:28:12 | hello | this is A idiot |
| 3 | 1 | 2007-11-29 14:34:33 | hello | dfssg |
+------------+-----------+---------------------+-------+---------------------+