Re: Fulltext SELECTing only part of a field entry

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/