Page 1 of 1

Select all rows where the dec row contains or ends with 0.

Posted: Thu Feb 01, 2007 11:21 am
by oskare100
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

Posted: Thu Feb 01, 2007 11:37 am
by Kieran Huggins

Code: Select all

SELECT * FROM `table` WHERE `dec` LIKE '%0'
?