title: MYSQL, How to combine the first 2 letters of the first name and the first 5 letters of the last name
body: <p>I'm trying to write an SQL query (using the SELECT function) that will take the first two letters of the first name and the first 5 letters of the last name, then combine them and put them in a new column called "User Name." I've tried using the SUBSTRING and CONCAT functions together, but my syntax isn't right. Does anyone know how this could be done? </p>