Hello,
I need to select all rows * from a MySQL database where the dec column ends with 0 (or contains 0 if it is easier). How can I do that?
Best Regards
Select all rows where the dec row contains or ends with 0.
Moderator: General Moderators
- Kieran Huggins
- DevNet Master
- Posts: 3635
- Joined: Wed Dec 06, 2006 4:14 pm
- Location: Toronto, Canada
- Contact:
Code: Select all
SELECT * FROM `table` WHERE `dec` LIKE '%0'