Jump to content

queries using <>


neller

Recommended Posts

I have read the stickies and searched other threads but can't seem to find an answer, have not seen these in any of my mysql books either.

 

If you had this Query.....

 

SELECT DISTINCT ehorsename
				FROM entries
				WHERE rraceid = '1'
				AND ehorsename <> 'Horse Name'
				AND eprognum <> '' AND eprognum <> '0'

 

What are the <> doing? I'm used to using them for "less than" or "greater than" but they are clearly not being used for this here, when used together do they mean something else?

 

thanks

Link to comment
https://forums.phpfreaks.com/topic/188381-queries-using/
Share on other sites

Though I must say that because of your rep. my first thought was that they removed it and had to look it up to be sure :D

I have a rep? :shy:  Anyway, it is indeed good to always take a peek at the manual for the authority on things (and if the manual is wrong, file a bug report!). It is often my first port of call when answering a question (but shh, I'm giving away my secrets to answering Qs!).  :)

Link to comment
https://forums.phpfreaks.com/topic/188381-queries-using/#findComment-994975
Share on other sites

I have a rep?

 

Yeah unless they give those @php.net e-mails away for free?!? Plus your recent Guru promotion means your words have a much higher-value then if some john doe said something, like me :P.

 

It is often my first port of call when answering a question (but shh, I'm giving away my secrets to answering Qs!)

 

I believe this is everyone's secret :) I already got the manual on speed dial :D Plus because of the authority the PHP manual has on Google it' easy for me to just type:

 

php some_function

 

In my Firefox URL address bar which is the same as I'm feeling lucky on Google search add in a nice add-on and you can just type the function name in the upper right search bar of Firefox, what's not to like? PHP Manual ROCKS!!

Link to comment
https://forums.phpfreaks.com/topic/188381-queries-using/#findComment-994977
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.