[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    Re: [PHP-DB] Fulltext SELECTing only part of a field entry
From:       Chris <dmagick () gmail ! com>
Date:       2006-11-26 23:33:37
Message-ID: 456A2451.8080705 () gmail ! com
[Download RAW message or body]

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

[prev in list] [next in list] [prev in thread] [next in thread]