[thelist] sql and databases

[Hassan Schroeder]

Peter Brunone (EasyListBox.com) wrote:
> 	Is this a SQL Server database?  You might look into full-text
> searching.

or MySQL -- full-text indexing is definitely what you want.

> If someone searches for "JOHNNY CASH AND THE FUNKY FRESH BAND" and the 
> actual artist title is JOHNNY CASH WITH THE FUNKY FRESH BAND, no results
> appear.
> 
> "johnny cash funky fresh" also would not turn up any results

Just did a quick test with the above, plus "funky fresh johnny cash"
and they all return the correct entry.

Even if you're not using MySQL, this should probably provide some
insight:  <http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html>

HTH,
-- 
Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

                           dream.  code.