Select all but the first character in the line

Question

How can you return a string minus the first character in a string in MySQL?

In other words, get "ello" from "hello."

The only way I can do this is to use mid (), with the second offset being larger than it can be:

select mid('hello', 2, 99) 

But I am convinced that there must be a more elegant way to do this. There is?

Answer 1

Use SUBSTR (or SUBSTRING ):

 SELECT SUBSTR( 'hello', 2 ); --> 'ello' 

See also: MySQL String Functions

Answer 2

This is really wrong. If you do, you will only get llo. To get everything after the first character .... do the following:

 <?php echo substr('hello', 1); // Output ello echo '<br />'; echo substr('hello', 2); // Output llo ?> 

I just wanted to fix it.

Edit: Bah, ignore me. I thought you were talking in PHP. In any case, you can do it in Mysql..or you can just get it in PHP, as I wrote above.

Answer 3

what about select substr ('hello', 2)?