Powered by BlogCFM http://www.dougboude.com/blog <p><font size="2" face="Verdana">Ever had the need to insert a record, but only wanted to do so if the record doesn't already exist? Typically the first approach to this is two queries: one to check for the existence of the values you want to insert, the second to peform that insert IF the first query returned no records. Well, I was in such a spot today, but hated the idea of having to hit the db twice to perform a conditional insert. Though I'm http://www.dougboude.com/blog/1/2010/05/CONDITIONAL-INSERT-IN-A-SINGLE-QUERY.cfm 2010-05-17T13:33:00-05:00 goog,mysql, code snippets <p><font size="2" face="Verdana"><strong>The Scenario</strong></font></p> <p><font size="2" face="Verdana">You're writing code to perform authentication for a web-based app. Your users live in one table (Site_User), your list of site permissions live in another table (systemRoles), and the two are related via a junction table (jctUserRole) that manages the many to many relationship there. Your backend database: MySQL version 5 or better.</font>< http://www.dougboude.com/blog/1/2009/12/A-SWEET-Little-MySQL-Function-GroupConcat.cfm 2009-12-21T11:29:00-05:00 goog,mysql, code snippets