Closed

Write a mysql query for me

This project received 25 bids from talented freelancers with an average bid price of $39 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
25
Project Description

Hello,

I'm looking for someone who can write a mysql query for me.

I'm developing a recipe site and am looking for a way to select recipes from a database and order them based on how many of the recipe's ingredients match the ingredients of the user's pantry table.

I have four tables in my database

recipes
id, name, prep_time

ingredient_types (static list of all ingredients in the world)
id, type

ingredients (for each recipe posted a record is created for the ingredient needed)
id, ingredient_type_id, recipe_id

pantry (a table containing records of each ingredient a user has at home)
id, ingredient_type_id


I was hoping to pull recipe data using fulltext search and in the same query check how many matches each ingredient of the recipe has to the user's pantry table and then order the output of the recipe data based on the number of ingredient matches.

Query must be

Thanks,

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online