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 ?
sashiksu
0
Light Poster
Recommended Answers
Jump to PostThe 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?
All 4 Replies
cereal
1,524
Nearly a Senior Poster
Featured Poster
Reverend Jim
4,678
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
rch1231
169
Posting Shark
AndrisP
193
Posting Pro in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.