Snipplr - assbach http://snipplr.com/users/assbach/tags/mysql Recent snippets posted on Snipplr.com en-us Wed, 15 Feb 2012 13:58:11 GMT (SQL) SELECT older than x days http://snipplr.com/view/2207/select-older-than-x-days/ 2 things here. currency (euro) with in a 2.00 format and select entries older than 4 weeks = 28 days

]]> Sun, 25 Feb 2007 08:32:05 GMT http://snipplr.com/view/2207/select-older-than-x-days/ (SQL) now plus 20 years http://snipplr.com/view/2193/now-plus-20-years/ useful if a "valid until" should have an exact ( in this case far future ) value.

]]> Wed, 21 Feb 2007 10:51:40 GMT http://snipplr.com/view/2193/now-plus-20-years/ (SQL) SELECT REPLACE http://snipplr.com/view/2156/select-replace/ This replaces a special character (used as a delimitter in a string i.e.) with some other char

]]> Sun, 11 Feb 2007 07:44:32 GMT http://snipplr.com/view/2156/select-replace/ (PHP) SELECT with conditional WHERE parts http://snipplr.com/view/1806/select-with-conditional-where-parts/ Building a SELECT with conditional WHERE parts, given from form-get parameters.

]]> Fri, 15 Dec 2006 09:02:45 GMT http://snipplr.com/view/1806/select-with-conditional-where-parts/