Archive for the ‘MySQL’ Category

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 […]


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 […]