Misspell
Jan 12th, 2008, 04:58 PM
Could someone lead me in the right direction with this; weather examples, explanation or the correct terminology so i can narrow my results down.
I would like to search a MySQL field (Like %WhatEver%) and display 10 words before the "Search Word" and 10 words after... or 75 characters before and after.
As of now im not using Full-Text, just a normal text field. Im capable of searching the field and displaying the results, but im looking for a 'MySQL Function' so i do not have to write my own.
Im thinking a built-in-function would be more effeint and faster then "phasing" through the results with a custom function, would that be correct thinking ?
Thanks for any insight.
_
I would like to search a MySQL field (Like %WhatEver%) and display 10 words before the "Search Word" and 10 words after... or 75 characters before and after.
As of now im not using Full-Text, just a normal text field. Im capable of searching the field and displaying the results, but im looking for a 'MySQL Function' so i do not have to write my own.
Im thinking a built-in-function would be more effeint and faster then "phasing" through the results with a custom function, would that be correct thinking ?
Thanks for any insight.
_