title: order by find_in_set(), and_then, and_then
body: <p>This mysql query doesn't seem to work for me:</p>
  
  <pre><code>select *
  from myTable
  order by
    find_in_set( category, "First, Second" ),
    sortby,
    title;
  </code></pre>
  
  <p>Apparently you can't order beyond the find_in_set function?</p>
  
  <p>Is there a way around this?  Am I missing something?</p>
  
  <p>Thanks for your reply.</p>
  
  <p>Edit:</p>
  
  <p>This is the exact query being run:</p>
  
  <pre><code>select
    uid,
    category,
    title,
    summary,
    image_url,
    link_url,
    link_text
  from links_and_documents
  where link_url != ''
    and status=1
  order by
    find_in_set( category, "Test_Category_Two,Test_Category_One" ),
    sortby,
    title;
  </code></pre>
  
  <p>It returns all the items you would expect but orders them by sortby and completely ignores the find_in_set function.</p>
  
  <p>If I leave <code>,sortby,title</code> off the end of the query it sorts items by the find_in_set function.:</p>
  
  <pre><code>select
    uid,
    category,
    title,
    summary,
    image_url,
    link_url,
    link_text
  from links_and_documents
  where link_url != ''
    and status=1
  order by
    find_in_set( category, "Test_Category_Two,Test_Category_One" );
  </code></pre>
  
  <p>Thanks for taking a look.</p>
  
  <p>Table Structure:</p>
  
  <pre><code>CREATE TABLE `links_and_documents` (
    `id` int(11) NOT NULL auto_increment,
    `dateadded` varchar(19) NOT NULL default '',
    `dateupdated` varchar(19) NOT NULL default '',
    `uid` varchar(16) NOT NULL default '',
    `clientuid` varchar(16) NOT NULL default '',
    `status` char(1) NOT NULL default '1',
    `sortby` varchar(16) NOT NULL default '',
    `category` text NOT NULL,
    `title` text NOT NULL,
    `information` text NOT NULL,
    `summary` text NOT NULL,
    `services` text NOT NULL,
    `link_url` text NOT NULL,
    `link_text` text NOT NULL,
    `document_url` text NOT NULL,
    `document_text` text NOT NULL,
    `image_url` text NOT NULL,
    PRIMARY KEY  (`id`),
    KEY `uid` (`uid`),
    KEY `category` (`status`,`category`(30))
  )
  </code></pre>
  
  <p>I receive no errors.</p>