MySQL Forums
Forum List  »  Full-Text Search

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem With Search Operators
2357
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.