Snipplr http://snipplr.com/language/sql/tags/select Recent snippets posted on Snipplr.com en-us Sun, 26 May 2013 09:40:33 GMT (SQL) SQl Select cluase value conversion - kashif21 http://snipplr.com/view/51434/sql-select-cluase-value-conversion/

]]> Fri, 01 Apr 2011 21:45:45 GMT http://snipplr.com/view/51434/sql-select-cluase-value-conversion/ (SQL) Select Duplicates - traeregan http://snipplr.com/view/41040/select-duplicates/

]]> Sun, 26 Sep 2010 03:37:19 GMT http://snipplr.com/view/41040/select-duplicates/ (SQL) SQL UPDATE SELECT - thomasvdb http://snipplr.com/view/20096/sql-update-select/

]]> Wed, 23 Sep 2009 04:40:56 GMT http://snipplr.com/view/20096/sql-update-select/ (SQL) select count - manec http://snipplr.com/view/11070/select-count/

]]> Sun, 11 Jan 2009 05:48:32 GMT http://snipplr.com/view/11070/select-count/ (SQL) Duplicate or clone one or more rows in MySQL - gfazioli http://snipplr.com/view/10982/duplicate-or-clone-one-or-more-rows-in-mysql/

]]> Wed, 07 Jan 2009 12:05:59 GMT http://snipplr.com/view/10982/duplicate-or-clone-one-or-more-rows-in-mysql/ (SQL) Find all categories NOT used in current item - stavelin http://snipplr.com/view/8523/find-all-categories-not-used-in-current-item/ It's easy to find the categories used on one item, but find all categories NOT used on current item? This snippet stores a "NOT IN" query. This is used with PHP & mySQL. The query can be written differently on other databases, but this seems to work with mySQL.

]]> Sun, 21 Sep 2008 16:03:24 GMT http://snipplr.com/view/8523/find-all-categories-not-used-in-current-item/ (SQL) UPDATE, falls Eintrag schon vorhanden, sonst INSERT - drk http://snipplr.com/view/5614/update-falls-eintrag-schon-vorhanden-sonst-insert/ Wenn ein INSERT einen doppelten Wert erzeugen würde, wird das UPDATE ausgeführt.

]]> Sun, 30 Mar 2008 10:20:13 GMT http://snipplr.com/view/5614/update-falls-eintrag-schon-vorhanden-sonst-insert/ (SQL) Update from select - wolfie http://snipplr.com/view/5150/update-from-select/

]]> Thu, 21 Feb 2008 11:56:51 GMT http://snipplr.com/view/5150/update-from-select/ (SQL) Ordering multiple SELECT statements in a UNION - andyhartleeds http://snipplr.com/view/4076/ordering-multiple-select-statements-in-a-union/

]]> Tue, 06 Nov 2007 08:43:28 GMT http://snipplr.com/view/4076/ordering-multiple-select-statements-in-a-union/ (SQL) SELECT REPLACE - assbach 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/ (SQL) select count distinct - goodkail http://snipplr.com/view/250/select-count-distinct/

]]> Thu, 06 Jul 2006 02:57:53 GMT http://snipplr.com/view/250/select-count-distinct/