MySQL Forums
Forum List  »  Newbie

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

Or...I just found this.

Wil this allow me to choose a certain number of words?

SELECT post_title, SUBSTRING_INDEX(post_content,' ',10) as page_content FROM wp_posts WHERE post_title= ");

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.