Problem With Search Operators
Posted by:
Tru Call
Date: June 03, 2006 06:50PM
Schema:
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
DROP TABLE IF EXISTS articles;
CREATE TABLE articles (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),body TEXT,
FULLTEXT (title,body)
);
INSERT INTO articles (title,body) VALUES
('Titolo di prova','descrizione articolo'),
('In diretta dall\'olimpico','AndrĂ in onda...');
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Query 1: SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('*dirett*' IN BOOLEAN MODE);
RS = 1 record
Query 2: SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('*olimp*' IN BOOLEAN MODE);
RS = 0 record
The second query return is empty, I don't understand why.
Any hints?
MySQL Version: 5.0.18
Thanks in advance.
Subject
Views
Written By
Posted
Problem With Search Operators
2445
June 03, 2006 06:50PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.