CODEWITHSUNDEEP
mysql
Bitmap
Bitmap

Reputation: 12538

Using <> in MySQL

I have come across <> used in a statement conditions a few times. Example:

SELECT param, d.param
FROM panel p join object d on p.id=d.id 
WHERE param IS NOT NULL and param<>''

Let me confirm the statement above has not been tested, it mimics some of the statements that I have come across.

My question is, what is the meaning of the the diamond <> condition?

Upvotes: 1

Views: 300

Answers (2)

Fender
Fender

Reputation: 3055

its the opposite of "equal" so it is "not equal".

in C it is !=

so in your question it means param is not a empty string

Upvotes: 2

Jacob
Jacob

Reputation: 43229

<> is like NOT .. = .. and !=. It means not equal.

MySQL comparison operators - not equal

Upvotes: 3

Related Questions