-
Archives
- April 2017
- April 2016
- July 2015
- November 2014
- October 2014
- June 2014
- May 2014
- January 2014
- December 2013
- October 2013
- April 2013
- April 2012
- October 2011
- July 2011
- April 2011
- March 2011
- February 2011
- May 2010
- April 2010
- January 2010
- October 2009
- June 2009
- May 2009
- April 2009
- February 2009
- October 2008
- September 2008
- August 2008
- July 2008
- January 2008
- December 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
-
Meta
Category Archives: SQL
SQL: Select duplicate rows, select indistinct rows
Using SQL, MySQL or whatever your favorite database may be, we all know using SELECT DISTINCT will return unique values in case a value appears more than once in a table. How do you fine duplicates? What if I want … Continue reading
Quick Character Escaping in PHP
When writing PHP web apps, I tend to run in to a portability issue when dealing with SQL connectivity. Since I can’t count on having the PEAR DB module available, I rolled my own set of functions to interact with … Continue reading
Posted in php, Programming, SQL
Leave a comment