Snipplr

(CSS) styling as per mime type / type of linked item - skopp

Wed, 29 Aug 2012 22:55:01 GMT

Style links depending on file format Since CSS3 you can style links depending on some rules also called attribute selectors. This is extremely convenient if you have files in PDF, Zip among other and you want to display a small icon near it. With this technique you can do it without including an image on your link. This snippet shows a small icons next to your links telling the user if it is an external link, an email, a pdf, a zip or whatever you would like.

(SQL) Where clause to select multiple rows of unique values - the_construct

Thu, 05 Jan 2012 21:42:32 GMT

Where clause to select multiple rows of unique values

(MySQL) MySQL Where - Masis

Fri, 11 Jun 2010 12:48:29 GMT

The WHERE clause is used for extracting only those records that fulfill a specified criterion. If you wanted to select only certain entries of your table, then you would use the keyword WHERE. WHERE lets you specify requirements that entries must meet in order to be returned in the MySQL result. Those entries that do not pass the test will be left out. To get PHP to execute the statement above you must use the mysql_query() function. This function is used to send a query or command to a MySQL connection. The following example selects all rows from the Persons table where FirstName='Peter':

(MySQL) Conditional String Replace - iroybot

Tue, 22 Sep 2009 09:11:41 GMT

as a note to self... in order to find it laters... This will only alter the value of fieldname if the conditions in the WHERE clause are met. With replace we only replace a certain string within fieldname with the replace_with string

(SAS) How to detect missing values using Arrays - sarathannapareddy

Tue, 31 Mar 2009 15:47:02 GMT

Direct link: http://ssc.utexas.edu/consulting/answers/sas/sas65.html

(PL/SQL) UPDATE using WHERE CURRENT OF clause - stews

Wed, 17 Sep 2008 17:16:50 GMT

I can never remember the syntax on the "FOR UPDATE OF" clause!

(PHP) SELECT with conditional WHERE parts - assbach

Fri, 15 Dec 2006 09:02:45 GMT

Building a SELECT with conditional WHERE parts, given from form-get parameters.