search engine

hello experts, i wanna know how do we create a search engine for your own database driven website. I wanna search the "ENTIRE MYSQL DATABASE" for any result matching the search text. Which means not only one or two tables. Plus i think this will certainly danger security because the tables include the table for storing username and password also. So, i wanna know the standard method followed.

re: search engine

You can do this by using SQL statements to query your databases. You can specify the columns you wish to return and thus reducing secuirty issues.

Check out: http://www.w3schools.com/sql/default.asp