document.write('<link rel="stylesheet" href="http://gist.github.com/stylesheets/gist/embed.css"/>')





document.write('<div id=\"gist-82891\" class=\"gist\">\n  \n  \n    \n            \n\n      <div class=\"gist-file\">\n        <div class=\"gist-data gist-syntax\">\n          \n          \n          \n            <div class=\"gist-highlight\"><pre><div class=\"line\" id=\"LC1\"><span class=\"k\">SELECT<\/span> <span class=\"n\">col1<\/span><span class=\"p\">,<\/span> <span class=\"n\">col2<\/span><span class=\"p\">,<\/span> <span class=\"n\">col3<\/span><\/div><div class=\"line\" id=\"LC2\"><span class=\"k\">FROM<\/span> <span class=\"n\">table1<\/span><\/div><div class=\"line\" id=\"LC3\"><span class=\"k\">WHERE<\/span> <span class=\"n\">col1<\/span> <span class=\"k\">IN<\/span> <span class=\"p\">(<\/span><span class=\"s1\">&#39;z&#39;<\/span><span class=\"p\">,<\/span> <span class=\"s1\">&#39;x&#39;<\/span><span class=\"p\">,<\/span> <span class=\"s1\">&#39;y&#39;<\/span><span class=\"p\">)<\/span><\/div><div class=\"line\" id=\"LC4\"><span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">find_in_set<\/span><span class=\"p\">(<\/span><span class=\"n\">col1<\/span><span class=\"p\">,<\/span> <span class=\"s1\">&#39;z,x,y&#39;<\/span><span class=\"p\">);<\/span><\/div><\/pre><\/div>\n          \n        <\/div>\n\n        <div class=\"gist-meta\">\n          <a href=\"http://gist.github.com/raw/82891/90d8633593611e4cc22d64ff6451c0c3f02f8494/order_by_set.sql\" style=\"float:right;\">view raw<\/a>\n          <a href=\"http://gist.github.com/82891#file_order_by_set.sql\" style=\"float:right;margin-right:10px;color:#666\">order_by_set.sql<\/a>\n          <a href=\"http://gist.github.com/82891\">This Gist<\/a> brought to you by <a href=\"http://github.com\">GitHub<\/a>.\n        <\/div>\n      <\/div>\n    \n  \n<\/div>\n')
