SQL Like Command - how to find records without 1-9 but using 0

[sashiksu]

Hey ! I'm looking for sql 'like' command help....
I had mysql database and it had settlement table. On that table there is column named 'settlement'.
In the settlement column there are so many amounts.....
Now I want to find recors '0 values'
Can anybody help me ?

[cereal]

The column is a string type and the value is literally something like 0 values or is an integer, float column?

Can you show the table schema and an example of data?

[Reverend Jim]

Based on what you've said the command would be something like

SELECT * FROM settlement WHERE settlement = 0

[rch1231]

I have found it is a good idea to cover the records where the field is blank, 0 or null with something like:

SELECT * FROM settlement WHERE settlement < 0.01 or settlement IS NULL

I realize this will get records where the settlement is not zero but sometimes you need to know about these. I inherited a database that had values like 0.00033 stored for the balance and I queried for value = 0 and was missing records.

[AndrisP]

I think NULLIF(settlement, 0) IS NULL is better than settlement < 0.01 or settlement IS NULL
Try this:

SELECT * FROM settlement WHERE NULLIF(settlement, 0) IS NULL