making search engine

[duoie]

Hello buddies

I want to make a simple search engine that will look through my web pages. The content of each page is stored in a field of a table. I do the following

select page_title from sth where content like '%user's query%'

this brings me the names of the proper pages. I want to know and be able to show the correct matches for every page so i can sort the results. How can i change my query for doing that ? I think that i should use a subquery but i have no idea what to put.

Thanks in advance for your inputs -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[foghorn]

Check out FULLTEXT indices in the MySQL documentation. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --