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

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

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