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 ?
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.