Export MySQL column aliases in phpMyadmin
<p>I am currently moving from one ticketing system to another. The table columns are close but not quite. I can run a query that will change the column name to what I need. However, when I export I am getting the original column name. </p>

<p>Here is the query with alias: 
SELECT u.id AS staff_id
FROM users AS u</p>

<p>This gives me what I need. However when I export it, it is showing the original column names. Is there a way to keep the alias when exporting?</p>