title: Mysql - Insert string with white space
body: <p>How do I insert string with white spaces in VARCHAR? </p>
  
  <pre><code>insert into users (user_id,firstname,lastname,email,group) values('admin','some','Body','admin@something.com','Site admin');
  </code></pre>
  
  <p>This is giving me syntax error, I am new to mysql, I went through mysql documentation that doesnt give me clear idea why this behavior is.  </p>
  
  <pre><code> mysql&gt; insert into users (user_id,firstname,lastname,email,group) values('admin','some','Body','admin@something.com','Site admin');
  ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group) values('admin','some','Body','admin@something.com','Site admin')' at line 1
  </code></pre>