Re: ignore the first sting in order

Hi Aleksandar, On Mon, Apr 08, 2002 at 04:43:11PM +0200, Aleksandar Bradaric wrote: > > Table example: > > _The Rock > > Scary Movie > > X-Files > > > With order I want the output > > Scary Movie > > _The Rock > > X-Files > > After reading your message again, look like this is what > you've

Re: ignore the first sting in order

Hi, > Table example: > _The Rock > Scary Movie > X-Files > With order I want the output > Scary Movie > _The Rock > X-Files After reading your message again, look like this is what you've been searching for. Sorry :( select * from movies order by substring_index(movietitle, '_', -1); And

Re: ignore the first sting in order

On 8 Apr 2002, at 13:52, Bernd Menzel wrote: > I want to order a result with ignore the first word when it begins with a _. > Begin the first word with a _ use the next word. > > Can I do it with SQL? > > Table example: > _The Rock > Scary Movie > X-Files > > With order I want the output > Sca

Re: ignore the first sting in order

Hi, > Table example: > _The Rock > Scary Movie > X-Files > With order I want the output > Scary Movie > _The Rock > X-Files select * from movies order by trim(leading from replace(movetitle, '_', ' ')); Regards, Sasa »mysql, select, database« --

ignore the first sting in order

Hi all, I want to order a result with ignore the first word when it begins with a _. Begin the first word with a _ use the next word. Can I do it with SQL? Table example: _The Rock Scary Movie X-Files With order I want the output Scary Movie _The Rock X-Files Thanx Bernd