Re: MATCH and return some text

[Barry]

Taco Fleur schrieb:

Hi all,
 
is it possible to do a MATCH AGAINST and return some of the text, for

example the first paragraph that contains the matching words?
 
Kind regards,
 

Well you can use the substring function if mysql for that.

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

good luck

Barry

--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MATCH and return some text

[Taco Fleur]

Hi all,
 
is it possible to do a MATCH AGAINST and return some of the text, for
example the first paragraph that contains the matching words?
 
Kind regards,
 

Taco Fleur 

Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox  http://www.pacificfox.com.au/ http://www.pacificfox.com.au an
industry leader with commercial IT experience since 1994 .

*   

Web Design and Development 
*   

Accept online Credit Card payments www.commerceengine.com.au
http://www.commerceengine.com.au/  
*   

SMS Solutions, including developer API
*   

Domain Registration, .COM for as low as fifteen dollars a year,
.COM.AU for fifty dollars two years!