Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the meaning of <> in mysql query?

Tags:

sql

mysql

I have a MySQL query that includes <> in it. I don't know the exact usage of it.

SELECT * FROM table_laef WHERE id = ? AND genre_type <> 'LIVE' 

P.S.: Im sorry for this basic syntax, since I have searched for this on Google. All they give is about <=>. Thanks anyway, guys!

like image 522
Manoj venk Avatar asked Aug 22 '16 08:08

Manoj venk


People also ask

What does <> mean in database?

It (<>) is a function that is used to compare values in database table. != (Not equal to) functions the same as the <> (Not equal to) comparison operator. Follow this answer to receive notifications.

What is <> in SQL Where?

The SQL WHERE Clause The WHERE clause is used to filter records. It is used to extract only those records that fulfill a specified condition.

What is the meaning <> 0 in SQL?

“Every [SQL] data type includes a special value, called the null value,”0 “that is used to indicate the absence of any data value”.1. The null value does not indicate why a value is absent—it simply marks the places that do not have a data value.


1 Answers

<> is standard ANSI SQL and stands for not equal or !=.

like image 182
juergen d Avatar answered Sep 30 '22 20:09

juergen d