seach script

[DBallerz02]

I am looking for a search script or create my own that would search the table of
articles in my database and if it finds a match, I want it to display 20 letters before the word found and 20 letters after. How can I do that ? How do I start ?

[Aarakast]

If you wan't to do that script by yourself, you should look at the SQL-"function" LIKE:

SELECT `title` FROM `table` WHERE `content` LIKE '%searchword%'

Aarakast

[liquidautumn]

start with learning FULLTEXT indexes

[DBallerz02]

thanks, I will look into it.

[Aarakast]

What is the advantage of FULLTEXT!?