473,396 Members | 2,017 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Full-text search: I want to get "all but oneword"

Hello,

I am facing two problems with Full-text search.

1° My query looks like:
SELECT id, title
FROM myTable
WHERE ((MATCH(title) AGAINST ('-myword' IN BOOLEAN MODE)))

I thought this could give me as result all rows but those that contain
"oneword" in their title.

What should I do to get the desired result ?
---
2° My query looks like:
SELECT id, title
FROM myTable
WHERE ((MATCH(title) AGAINST ('[Z3]' IN BOOLEAN MODE)))

Does not work. I would like to get rows containing "[Z3]" in their
title.
---
Can you please help me ? I already browsed the archive without
success.

Thank you in advance.

Sebastien
Jul 19 '05 #1
0 1553

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Phil Powell | last post by:
The table already has a fulltext index and from there I can use the MySQL fulltext search query to get results as well as the relevancy score. The problem I have is that MySQL has a default...
0
by: Shenron | last post by:
Hello, Does the fulltext search is a good way to find words in a table which contains more than 500'000 rows, moreover it will search in blob field. What's your opinion about fulltext in big...
0
by: Daniel Rossi | last post by:
Can someone please tell me if my problem with the punctuation in a fulltext= search is a bug or limitation? Ultimately the users of the system i built = do not want to have to try using the +...
0
by: steve | last post by:
I have 300k rows in my db, 1 gig of ram. I do fulltext indexing on a large field (textual). It appears that fulltext indexing puts a lot of strain on my server. I start bumping up iowait numbers...
8
by: Radim B | last post by:
Hi, can anyone help me if it is possible to make indexing for fulltext from formats in: 1) *.doc 2) *.xls 3) *.html 4) *.pdf Many thanx for your help
0
by: leegold2 | last post by:
I want to know on Solaris how I could lower the the minimum fulltext search string from 4 to 3. Right now using the FullText search any string less than 4 chars is ignored. I'm sure there's a link...
2
by: Marc | last post by:
Apologies if this is not the correct place to put this. I wrote this query to perform a fulltext search on tblPages. SELECT * FROM tblPages, FREETEXTTABLE(tblPages, *,@searchTerm) searchTable...
0
by: pcosway | last post by:
(originally posted in database.myodbc by mistake) I'm trying to speed up a fulltext search (MySQL 5.0.21, table has 670,000 records, about 900MBytes, machine has 1GB memory). Fulltext search...
1
by: luckysingh | last post by:
I've tried searching alot on the net but am not able to find how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates. Currently...
0
by: BobLewiston | last post by:
I did a full installation of SQL Server 2008 Express. Looking at Add / Remove Programs, I see the following pertinent programs installed: SQL Server 2008 SQL Server 2008 Browser SQL Server 2008...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.