Select last word in a string. 1

[petrosky]

Hi,

I have a SQL statement that currently selects the left most word of a Description field to return a brand only.

Some products have the brand as the last word in the Description field.

How would I go about selecting the Last word? Should I be approaching this from PHP?

Here is the Left which works for the first word...

SELECT Left(Description, INSTR(Description, ' ')-1 as Brand

Any ideas appreciated.

Peter.

Remember- It's nice to be important,
but it's important to be nice

 

[HarleyQuinn]

One way you can achieve this is by using SUBSTRING_INDEX()

Hope this helps

Andy
---------------------------------
[green]' Signature removed for testing purposes.[/green]

http://lessthandot.com

 

[ingresman]

try

 select reverse(left(reverse(Description), instr(reverse(Description),' ') -1)) from <table>

 

[r937]

ingresman, that's cute, but harley's suggestion is so much cleaner and simpler

SELECT SUBSTRING_INDEX(Description,' ',-1) as Brand

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[petrosky]

Thank you all for your help.

Kind regards,

Peter.

Remember- It's nice to be important,
but it's important to be nice

 

[ingresman]

thanks for the advice Rudy !