I have a table with 77 fields in MySQL. Quite a number of them start with the same prefix "mt3\_".
Instead of writing them all out, I wanted to use this syntax to select only those fields from the table that start with "mt3\_":

```
SELECT tablename.mt3_* from tablename;

```

However this does not work... What is the correct syntax to do this?

Thanks.