just wondering which inequality operator i should use in MySQL, or if it matters. != or <>? is one of them the standard way in other DBs (since we all know MySQL bends the standards a bit)?
thanks if anyone knows.
| SitePoint Sponsor |
just wondering which inequality operator i should use in MySQL, or if it matters. != or <>? is one of them the standard way in other DBs (since we all know MySQL bends the standards a bit)?
thanks if anyone knows.
- Matt
Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
"Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR





I think <> is more towards the standard, I have no real idea, I just think I remember using it in Access and SQL server.
Please don't PM me with questions.
Use the forums, that is what they are here for.
I'm pretty sure its just user preference.
Chris Beasley - I publish content and ecommerce sites.
Featured Article: Free Comprehensive SEO Guide
My Guide to Building a Successful Website
My Blog|My Webmaster Forums





<> is the SQL standard but virtually every RDBMS I've ever used supports both <> and !=. Take your pick.
Matt - Sybase DBA / PHP fanatic
Sybase/MySQL/Oracle | I don't like MySQL
Download Sybase | DBForums.com - for all your RDBMS talk
Bookmarks