使用不同的运算符获取mysql数据

Question

Is it possible to fetch data from a database adding a dot into it using MySQL?

e.g. If I've data inserted into a DB such as 'BA', after fetching the value can I display it as B.A?

Can I also change something from L_T to something like L/T?

Thanks

Answer 1

In case of BA to B.A do something like this:

SELECT LEFT(YOURCOLUMN, 1) + '.' + RIGHT(YOURCOLUMN, 1) FROM YOURTABLE

And for the other one I will let you guess :)