Move First Char of String to End of String Using MySQL Functions

Question

I'm trying to find an optimized way to move first Character of a Column to end of it, if first Character was '@' , Just when Showing data in DBGrid (Not permanently in database).

There are many Functions in MySQL, but I want to find the best way!

I show many (about 2000) records in DBGrid. Does it affect performance ?!

We can't tell that easily. Just try different ways and measure. You should also consider to handle this on application level. Usually this is faster. — fancyPants
– fancyPants, Commented Jan 7, 2014 at 13:24
Yeah,My Code is like this: SELECT (CASE WHEN ASCII(MyColumn)=64 THEN (CONCAT(SUBSTR(MyColumn,2),'@')) ELSE MyColumn END) FROM MyTable; But I think @fancyPants is right. It is better to handle it in application level ! — Jessica
– Jessica, Commented Jan 7, 2014 at 15:37

Ike Walker · Accepted Answer · 2014-01-07 13:33:01Z

1

Here is one way to do it. I would not expect it to materially affect performance on 2000 rows:

select concat(substr(your_column,2),left(your_column,1))
from your_table

answered Jan 7, 2014 at 13:33

Ike Walker

65.8k14 gold badges115 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jessica · Accepted Answer · 2014-01-07 21:19:19Z

0

Solution:

SELECT (CASE WHEN ASCII(MyColumn)=64 THEN (CONCAT(SUBSTR(MyColumn,2),'@')) ELSE MyColumn END) FROM MyTable;

p.s:64 is ascii code for '@'

But I think @fancyPants is right. It is better to handle it in application level !

I will use OnGetText Event in Dataset to handle it in my application.

answered Jan 7, 2014 at 21:19

Jessica

7251 gold badge10 silver badges23 bronze badges

Collectives™ on Stack Overflow

Move First Char of String to End of String Using MySQL Functions

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related