NOT RLIKE not working the way I want

[XpertWorlock]

Here is the query

SELECT * FROM files WHERE keywords RLIKE 'july' || keywords RLIKE '2008' && keywords NOT RLIKE 'membersonly' || title 
RLIKE 'july' || title RLIKE '2008'

 

I want any of the "keywords" to be brought up, as long as one of the keywords is not "membersonly" 

 

It works perfectly without it, but as I don't want the "membersonly" keyword, it decides to bring it up.

 

the way the column keywords is set up is each word has a space in between,

 

one row is 'membersonly july 2008'.

 

This shouldn't show up

 

What am I doing wrong here, I'm assuming it has to be just a bad query design.

[fenway]

Huh?

[XpertWorlock]

What part Huh?

 

I know its confusing, but if I understand what part is confusing, I'll explain better

[ninedoors]

Here is the query

SELECT * FROM files WHERE keywords RLIKE 'july' || keywords RLIKE '2008' && keywords NOT RLIKE 'membersonly' || title 
RLIKE 'july' || title RLIKE '2008'

 

I want any of the "keywords" to be brought up, as long as one of the keywords is not "membersonly" 

 

It works perfectly without it, but as I don't want the "membersonly" keyword, it decides to bring it up.

 

the way the column keywords is set up is each word has a space in between,

 

one row is 'membersonly july 2008'.

 

This shouldn't show up

 

What am I doing wrong here, I'm assuming it has to be just a bad query design.

 

Try using brackets like:

 

SELECT * FROM files WHERE (keywords RLIKE 'july' || keywords RLIKE '2008' || title 
RLIKE 'july' || title RLIKE '2008')  && keywords NOT RLIKE 'membersonly'

[XpertWorlock]

Yes it was fixed by proper comments, I knew it had something to do with that.

 

Didn't look right to me,

 

thanks