在sql查询中使用不等于

Question

I want to select all values that does not have a zero from the db using. But in this case I am getting all values with a zero too

SELECT column_name(s)
FROM table_name
WHERE column_name <> value

How do I get to use <> in the above query and achieve what I require.

Thanks Jean

Answer 1

This one select every row where colum_name is not value.

SELECT column_name(s)
FROM table_name
WHERE column_name <> value

This one select every row where colum_name does not have value in it. Is that your problem ?

SELECT column_name(s)
FROM table_name
WHERE column_name NOT LIKE '%value%'