ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming


MyASPN >> Mail Archive >> php-db
php-db
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

Privacy Policy | Email Opt-out | Feedback | Syndication
© 2004 ActiveState, a division of Sophos All rights reserved