Posts Tagged ‘MySQL’

Return MySQL Results from an “IN” Query in the Correct Order

By marc • Apr 29th, 2008

The scenario:
You have a list of ids in a particular order that you want to search for in a MySQL table. Perhaps the ids were returned in this order from a search index or something else. Whatever the case is, now you want to get the results in the same order as the ids that […]



Using Multiple Databases in Symfony with Propel

By marc • Apr 22nd, 2008

There comes a time in your symfony development career when you will need to connect to multiple databases from within one application. At first it may not be obvious how to configure symfony correctly to handle a couple different databases or database servers.



Useful MySQL Command Line Commands

By marc • Apr 18th, 2008

From time to time I need to perform some MySQL tasks that are only possible from the command line. Considering that I don’t have to use them everyday, I tend to forget the exact syntax for them. So then I am forced to take the time to search through google to find examples for the […]