[thelist] sql and databases
Andrew Martin
comitque at hotmail.com
Fri Aug 13 14:42:32 CDT 2004
I am working on a site for a record store. They have a database full of
artist names and album titles.
Using ASP, I currently use LIKE as a sql term, so SELECT * WHERE artist LIKE
'%" & searchterm & "%'"
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 because that
exact phase is not in the database.
How do I perform a more complicated search? Are there tutorials anywhere
for this?
Thanks!
More information about the thelist
mailing list