title: mysql create a hardcoded value within select statement
body: <p>I want to know if I can hardcode a value within my select statement. I have the following mysql query that I use to generate a list. </p>
  
  <p>I use <code>concat</code> to build this string as part of creating the list. 
  However, now I need to generate an 'Unknown' record as part of the list.  </p>
  
  <p>For example:</p>
  
  <pre><code>20(ABC Object #20)
  24(DEF Object #24)
  </code></pre>
  
  <p>I want to add a value of 'UKNOWN' to the top of the list:</p>
  
  <pre><code>--(UNKNOWN -- )
  20(ABC Object #20)
  24(DEF Object #24)
  </code></pre>
  
  <p>Here is what I have so far:</p>
  
  <pre><code>SELECT CAST(p.Serial AS UNSIGNED INTEGER) as Serial, 
  p.Object_ID, 
  p.Part_ID, 
  st.Description AS ObjectDesc, 
  s.Object_Num, 
  concat(Serial,' (',st.Desc,' #',s.Object_Num,')') as DropList 
  FROM Parts p LEFT JOIN Objects s ON p.Object_ID = s.Object_ID 
  LEFT JOIN ObjectTypes st ON s.ObjectType_ID = st.ObjectType_ID 
  </code></pre>
  
  <p>Can I hardcode that string in my select statement? If so, how do I do that?</p>