Re: Searching a mySQL DB

Check out the MySQL page at http://www.mysql.com/doc/F/u/Fulltext_Search.html. This page talks about doing full-text searches through your data. Then you can implement the queries using PHP scripts to perform the searches.. It works super smooth.. You do have to create an index of any column you want to be able to search but phpMyAdmin will do it for you if you are not familiar with how to do it. Later, Bob Weaver "Thomas Edison Jr." <thomasedisonjr@yahoo.com> wrote in message news:20020415110622.92238.qmail@web14102.mail.yahoo.com... > I'm working on a search program that searches on a > mySQL DB and gives back results. > > I have a table with a column vProName, which > let's say, contains a record "Basket Ball Game". > Now what i want is that if someone searches for "Game" > or "Ball", even then this record should appear. > > Could someone guide me for the same.... > > Thanks, > T. Edison Jr. > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/