This may be of use:
http://www.mysql.com/doc/en/Fulltext_Search.html

D.


"Mike Delorme" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>
>
>
> Hi,
>
> I have a table in DB Music that looks a little mike this:
>
> TABLE NAME
> _____________________________________________________
>      SONG NAME                SONG LYRICS
> |                       | |                          |
> |                       | |                          |
> |                       | |                          |
> |                       | |                          |
> |                       | |                          |
> |                       | |                          |
> |                       | |                          |
> |                       | |                          |
> |                       | |                          |
> |                       | |                          |
> |_______________________| |__________________________|
>
> In each row of SONG NAME is the name of a song and the corisponding lyrics
> are in the next colum. What I would like to do is set up a search in wich
> the client can enter a sequence of words. The search searches the DB table
> TABLE NAME and looks for the word sequence in the table. The printed
results
> are the song name and a link to the lyrics. Can this be done? And how can
it
> be done?
>
> Thanks,
> Michael Delorme
> www.HybridFusion.com
>
> _________________________________________________________________
> Protect your PC - get McAfee.com VirusScan Online
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to