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
