title: Save Variable in SQL
body: <p>Is there a way for me to save the values my <code>SELECT</code> statement returns in to a variable in SQL?</p>
  
  <p>This is what i want to do, first i want to <code>SELECT</code> all the columns i wanna check so in this case <code>ItemNames</code> of the items with <code>ItemCategory</code> US.</p>
  
  <pre><code>SELECT `ItemName` where `ItemCategory´= 'US'
  </code></pre>
  
  <p>Then I want to save the <code>ItemName</code> from the statement above into a variable in SQL to use it later on in the same query. Like this:</p>
  
  <pre><code>SELECT `DatabaseID` where `Project` NOT LIKE `myVariable`
  </code></pre>
  
  <p>Thanks in regards</p>