Link to home
Start Free TrialLog in
Avatar of thenone
thenone

asked on

Function to shorten column

I need a function that will make a column in my table from 29 words to 25 words another words shorten it from 29 words to 25 words.
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

you have to specify what you understand by "words".
For the others, the database is MySQL 5 (as from previous post)...

Avatar of thenone
thenone

ASKER

my mistake all of the words are seperated with a space.
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of thenone

ASKER

Yeah that should work a little sloppy but I only need it to run one time thanks angel