[SOLVED] If != in mysql?

[papaface]

Hello,

In an if statement we use if ($i != 0)...

But what is the syntax if I want to find all records in a column in a  table that dont equal 0 for example?

 

Thanks

[pocobueno1388]

<?php

$query = "SELECT * FROM table WHERE col != 0";
$result = mysql_query($query)or die(mysql_error());'

?>

[papaface]

In my case this doesnt seem to work:

AND paypal != ""

Im trying to find values that do not equal "" or " " in the paypal column.

[roopurt18]

  AND LENGTH(paypal) > 0

 

By the way, strings in SQL are written with single quotes, not double, unless I'm mistaken.

[papaface]

They can be written with either, it doesnt make a difference.

Thanks that worked

[Barand]

or you could have

 

WHERE paypal <> '' AND paypal <> ' '

 

or

 

WHERE paypal NOT IN ('', ' ')

[papaface]

Thanks