queries using <>

[neller]

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

[salathe]

It simply means "not equal", in MySQL it is the same as "!=".

[ignace]

in MySQL, I thought they were the same in PHP to, are they not?

[salathe]

ignace, <> is not a PHP operator.

[ignace]

ignace, <> is not a PHP operator.

 

http://www.php.net/manual/en/language.operators.comparison.php, are you sure?

[salathe]

Heh, my mistake. Though I can honestly say, I've never used it... always !=

[ignace]

Heh, my mistake. Though I can honestly say, I've never used it... always !=

 

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

[salathe]

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

I have a rep?   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!). 

[ignace]

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 .

 

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 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!!