MYSQL query if syntax

Question

I have a question regarding an SQL syntax.

I have a mysql table like this (id, name, subid, preview) where preview is set to 0 as default. So now I want to make a select to query only lines where preview is different from zero.

Can I do this in a single query .. or I need to query all and then make (if else) decisions?

like SELECT * FROM table_name; - and iterate through ... ?

score 1 · Answer 1 · answered Aug 05 '11 at 15:13

1

Put condition in WHERE

SELECT * FROM table_name
WHERE  preview !=0

answered Aug 05 '11 at 15:13

a1ex07

36,826
12
90
103

score 1 · Accepted Answer · answered Aug 05 '11 at 15:13

You could do

select *
from mytable
where preview != 0

!= means "not equal to". Some databases also use <> for the same meaning.

If preview is nullable, do you also want to return rows where preview is null? If so, you may want to try:

select *
from mytable
where preview != 0 or preview is null

score 1 · Answer 3 · answered Aug 05 '11 at 15:24

Also worth to point out is that while * will do fine, you should always try to specify which columns you need in your query, so it be more clear what the query actually retrieves, so

SELECT id, name, subid, preview from table_name WHERE preview != 0

is more clear than SELECT *, but anyway all the other answers are right too.

score 0 · Answer 4 · answered Aug 05 '11 at 15:13

0

What about

SELECT * FROM table_name WHERE preview != 0;

?

answered Aug 05 '11 at 15:13

Quasdunk

14,944
3
36
45

score 0 · Answer 5 · answered Aug 05 '11 at 15:14

0

You can simply use query like this: select * from table_name where preview <> 0

answered Aug 05 '11 at 15:14

Eugene Kuleshov

31,461
5
66
67

MYSQL query if syntax

5 Answers5