How To Exclude Similar Data That Exists In Different Columns?

[cwalker]

Here's my example…the syntax I'm using is tossing an error.

SELECT * FROM my_table WHERE entry_type=''

AND my_column7 NOT LIKE ('+ONE* +TWO +THREE*' IN BOOLEAN MODE);

AND my_column8 NOT LIKE ('+ONE* +TWO +THREE*' IN BOOLEAN MODE);

AND MATCH(my_column3) AGAINST('+ONE* +TWO +THREE*' IN BOOLEAN MODE);

The problem is caused by the condition (and my bad syntax) where I'm getting the match for my_column3 but it's including matches that are also (incidentally) in my_column7 and my_column8 that I DON'T want. I DO want to see my_column7 and my_column8 but I don't want them to cause them to be in my query results.

Advice and suggestions cheerfully accepted!

[peterlaursen]

First of this is 'outside scope' of the product support we offer. This is a general SQL question and not a SQLyog question. However if you can provide a small table dump that reproduces the problem we can look into it.

[Author]

Posts