i wish to create a site with lyrics of tunes(lyrics is going to be saved in mysql databases) .i wish to give a search function to ensure that a person can search by typing a couple of words.can there be any script which searches mysql database. if so then what it's? i'm very a new comer to programming.

This is a good resource to enable you to get began :


What you would like is full text search - http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html.

You need to look at this chapter from mysql manual about full text search in mysql.

You will find some third party solutions for this too: like Sphinx Search.

And methods of writing writing your own search/indexing mechanism.

How you can search a MySQL DB...

Essentially you need to create what we should call queries along with a special language referred to as SQL (Structured Query Language) can be used for this function.

Then you need to produce a web site with html which will take your research needs and run them on the server utilizing a language like PHP. The reply is then came back towards the user in the browser.

Now, you will find two methods for applying these queries.

  1. Make use of the standard search operator referred to as 'like'.

  2. Use what we should call 'full text searches'.

Option 1 has some benefits but when you've got a large database (with countless tunes) it may be reduced.

Option 2 features its own benefit of speed.

In a nutshell, if you are a starter, there is a lengthy approach to take, learning this stuff first.