gevensen Posted November 5, 2009 Share Posted November 5, 2009 omit is an enum deposit_link is an int(11) service_date is a date if I leave off AND `deposit_link` > '0' it works add it it returns zero rows but there should be 5 rows affected what am i doing wrong? UPDATE `sc_income` SET `omit` = '1' WHERE `service_date` < '2009-08-29' AND `deposit_link` > '0' Quote Link to comment https://forums.phpfreaks.com/topic/180426-solved-why-wont-this-query-work-should-be-simple/ Share on other sites More sharing options...
gevensen Posted November 5, 2009 Author Share Posted November 5, 2009 guess i found my own answer UPDATE `sc_income` SET `omit` = '1' WHERE `deposit_link` > 0 AND `service_date` < '2009-08-29' Quote Link to comment https://forums.phpfreaks.com/topic/180426-solved-why-wont-this-query-work-should-be-simple/#findComment-951864 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.