Category Archives: SQL

SQL: Select duplicate rows, select indistinct rows

Posted on October 27, 2008 by admin

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 →

Posted in How Tos, mysql, SQL | Tagged , , | 1 Comment

Quick Character Escaping in PHP

Posted on October 10, 2007 by admin

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