473,320 Members | 1,979 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,320 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 1301

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: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

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.