471,092 Members | 1,768 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 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 1481

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Phil Powell | last post: by
reply views Thread by Shenron | last post: by
reply views Thread by Daniel Rossi | last post: by
reply views Thread by steve | last post: by
8 posts views Thread by Radim B | last post: by
2 posts views Thread by Marc | last post: by

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.