search

UMM-CSci-4453-S19 / final-project-data-gangstaz-v2

final-project-data-gangstaz-v2 created by GitHub Classroom
0 stars 1 forks source link

Search #11

Open nkfoss opened 5 years ago

nkfoss commented 5 years ago

search for wines by name, keywords, reviewer, country, etc

michael-small commented 5 years ago

select * from taster join wineReviews on tasterFk=tasterId join location on locFk=locId where CONCAT(tasterId, name, twitter, locId, country, province, region, continent, description, designation, points, price, variety, winery, vintage) like '%%';

About 2.5 sec, but with 100 it's 0.04 sec.