[thelist] sql and databases
Hassan Schroeder
hassan at webtuitive.com
Fri Aug 13 17:52:22 CDT 2004
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.
More information about the thelist
mailing list