...

View Full Version : fuction to extract words



sujith
11-27-2006, 11:55 AM
SUBSTRING()
is the fuvtion to extract limtted number of charecters from a String of text.
But can any one say me wether there is any fuction to extract limitted number of words from a String of text

Hope u can help me
:)

harsh789
11-27-2006, 04:29 PM
try using SUBSTRING_INDEX(str,delim,count)

for ex. following query will return first 10 words from str

SELECT SUBSTRING_INDEX(str,' ',10) FROM table_name

sujith
11-29-2006, 07:47 AM
Thanks

sujith
11-29-2006, 09:39 AM
Thanks


Really i want its SQL Server Equallent

guelphdad
11-29-2006, 02:23 PM
you posted in the mysql forum, that is why you got a mysql answer. I'll move the thread to the general database area.

marek_mar
11-29-2006, 03:19 PM
And how did it land in the PHP forum?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum