Wednesday, 2 October 2013

What does operator mean, sql?

What does operator mean, sql?

I came accross the sql query where the <=> operator is put. What does <=>
operator mean?
SELECT STR_ID, TEX_TEXT AS STR_DES_TEXT, IF( EXISTS( SELECT * FROM
SEARCH_TREE AS SEARCH_TREE2 WHERE SEARCH_TREE2.STR_ID_PARENT <=>
SEARCH_TREE.STR_ID LIMIT 1 ), 1, 0) AS DESCENDANTS FROM SEARCH_TREE
This sql is of MySQL type.

No comments:

Post a Comment