#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Posts
    2
    Rep Power
    0
    Is the NOT logical operator supported in MySQL.. For example i'm running this query but it doesn't seem to work

    Select DISTINCT(username) FROM users WHERE (username LIKE '%something%' OR username LIKE '%something'%) AND username NOT LIKE '%somethingelse%' AND username NOT LIKE '%something%'
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,642
    Rep Power
    4492
    This works fine for me in version 3.23.25 on windows. Are you getting an error or just not getting the results you thought you would?

    ---John Holmes...
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Posts
    2
    Rep Power
    0
    I'm not getting the results I want. I'm on Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i586) I will try to update the version and see what happens..

Similar Threads

  1. Operator Overloading
    By notJoeKing in forum C Programming
    Replies: 2
    Last Post: February 17th, 2004, 09:53 AM
  2. STL: overloading operator + problem
    By kucing in forum C Programming
    Replies: 6
    Last Post: January 17th, 2004, 04:54 AM
  3. how does char* work???
    By MillionBacteria in forum C Programming
    Replies: 18
    Last Post: December 12th, 2003, 10:38 AM
  4. How do I store an operator in a variable?
    By raklet in forum Perl Programming
    Replies: 7
    Last Post: October 26th, 2003, 10:27 AM
  5. what logical operator to use?
    By damon129 in forum PHP Development
    Replies: 5
    Last Post: February 12th, 2002, 01:20 PM

IMN logo majestic logo threadwatch logo seochat tools logo