MySQL Forums
Forum List  »  Newbie

Re: Copying just a short part of one field to another when the field is blank
Posted by: Monika
Date: April 15, 2005 05:31AM

Hi Lara

Of course you can change the lenght in your SUBSTRING function to any length you wish to.
So far I haven't used SUBSTRING_INDEX but if you use blanks as delimiters you should be able to select the first 10 words of your content.

http://dev.mysql.com/doc/mysql/en/string-functions.html

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.