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

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

benmoreassynt

2006-11-24, 6:56 pm

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:
[color=darkred]
> 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!

Sponsored Links