Re: Fulltext SELECTing only part of a field entry

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux