Re: RE: [PHP-DB] Fulltext SELECTing only part of a field entry
| From: | benmoreassynt | 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!
>>