benmoreassynt wrote:
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.
That's not going to be fast even with indexes :( Not sure what you
I guess you will still need to get the whole texts, but do the selecting
befores displaying results. There are functions to to select an amount of
text of certain lenght, starting at certain point of the string.
-Original Message-
From: benmoreassynt [mailto:[EMAIL PROTECTED]
Sent:
/11/24 Fri PM 01:19:31 EST
To: benmoreassynt [EMAIL PROTECTED], php-db@lists.php.net
Subject: RE: [PHP-DB] Fulltext SELECTing only part of a field entry
I guess you will still need to get the whole texts, but do the selecting
befores displaying results. There are functions to to select
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