June 25th, 2012, 06:00 PM
NOT vs != vs <>
Just need to confirm, these 3 are exactly the same:
NOT ( customers.name = 'A.Jones' )
WHERE customers.name != 'A.Jones'
WHERE customers.name <> 'A.Jones'
June 25th, 2012, 08:01 PM
yes, they are... in mysql
Originally Posted by zxcvbnm
but one of them will not work in all other database systems
it took more than the usual three seconds to find the right search phrase in google, and this was among the resuts --
June 25th, 2012, 09:53 PM
Sometimes I wonder:
Originally Posted by r937
Imagine a world with 1 type of AC adapter, 1 brand of computer where everythign is compatible with everything, 1 USB port, only php and not asp, not cold fusion, only mysql and not sql light, explode and not list and ....
Not gonna happen.