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. 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? 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 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' 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 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
Archived
This topic is now archived and is closed to further replies.