November 8th, 2000, 06:27 PM
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%'
November 9th, 2000, 04:09 AM
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?
November 9th, 2000, 02:28 PM
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..