mysql - How to achieve TRIM on a SELECT * query -

mysql's trim function works great when specifying particular column name, in:

select trim( both "'" channelurl ) posts 

i need achieve same result when doing "select *" query.

this not work:

select trim( both "'" * ) posts 

is there one-step process achieves outcome?

you have have specify fields trim,

select trim(both "'" field1) field1, trim(both "'" field2) field2 posts 

for example if have auto_increment field in table wont work in trim function.