XpertWorlock Posted March 26, 2010 Share Posted March 26, 2010 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. Quote Link to comment https://forums.phpfreaks.com/topic/196591-not-rlike-not-working-the-way-i-want/ Share on other sites More sharing options...
fenway Posted March 26, 2010 Share Posted March 26, 2010 Huh? Quote Link to comment https://forums.phpfreaks.com/topic/196591-not-rlike-not-working-the-way-i-want/#findComment-1032366 Share on other sites More sharing options...
XpertWorlock Posted March 27, 2010 Author Share Posted March 27, 2010 What part Huh? I know its confusing, but if I understand what part is confusing, I'll explain better Quote Link to comment https://forums.phpfreaks.com/topic/196591-not-rlike-not-working-the-way-i-want/#findComment-1032638 Share on other sites More sharing options...
ninedoors Posted March 27, 2010 Share Posted March 27, 2010 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' Quote Link to comment https://forums.phpfreaks.com/topic/196591-not-rlike-not-working-the-way-i-want/#findComment-1032714 Share on other sites More sharing options...
XpertWorlock Posted March 28, 2010 Author Share Posted March 28, 2010 Yes it was fixed by proper comments, I knew it had something to do with that. Didn't look right to me, thanks Quote Link to comment https://forums.phpfreaks.com/topic/196591-not-rlike-not-working-the-way-i-want/#findComment-1033247 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.