I have a select statement like this

select field1, field2  
  from table1

What I want is to have a newfield with only value "example".

newfield does not exist in the table, but when I run this query it kinda makes a virtual column with the values of example field.

sql mysql
Edit
Report