Re: [PHP-DB] Fulltext SELECTing only part of a field entry
by Chris other posts by this author
Nov 26 2006 3:36PM messages near this date
Re: RE: [PHP-DB] Fulltext SELECTing only part of a field entry
|
[PHP-DB] Re: Just two PHP questions
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 can
do about it though. You either need to do it in the database or php, so
one of them will be a memory / cpu hog :/
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thread:
Benmoreassynt
Miguel Guirao
Steven Cruz
Benmoreassynt
Chris
|