Re: RE: [PHP-DB] Fulltext SELECTing only part of a field entry

From: Date: Fri, 24 Nov 2006 21:40:24 +0000
Subject: Re: RE: [PHP-DB] Fulltext SELECTing only part of a field entry
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-42747@lists.php.net to get a copy of this message
Thank you very much. Could you give me a rough idea of what the MySQL query would look like? I am trying to work out the syntax using string functions like LOCATE, INSTR, SUBSTRING and SUBSTRING_INDEX. Many thanks BMA Steven Cruz wrote: > I use to perl scripts to do something like this. But you just back and > forward from the location in the string you are. You are count for word > bounderies, in short, mostly white spaces. Next you count the number of > characters, and substring! >>

« previous php.db (#42747) next »