Write a mysql query for me

Closed

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,

Skills: Data Processing, PHP

See more: Write from home, write for me, s&me, order processing from home, order processing at home, n query, me at home, matches list, list matches, id me, i can write my name, how can i write a, write mysql processing, write queries mysql, write mysql query, how to write recipes, how to write a recipe, write`, write, write s, write query, write c++, write a , query table, pantry

Project ID: #349070

25 freelancers are bidding on average $39 for this job

prashant29

################ Please check your PMB ##############

$50 USD in 1 day
(6 Reviews)
6.2
jeevanoss

I can do this work.Pls see the PMB for details

$30 USD in 1 day
(38 Reviews)
6.3
allandmore

Hello, I can do this query for you in a day. Kindest regards, sduras

$50 USD in 1 day
(6 Reviews)
3.6
vikaskumra

I can do this job for you...

$40 USD in 1 day
(1 Review)
2.6
rubito

Hi. I can do this quickly fast.Best regards Ruben

$50 USD in 1 day
(4 Reviews)
2.4
jenwork

Sir,Please viw PMB

$30 USD in 1 day
(3 Reviews)
2.6
dashmmWEBIL

please see pm

$30 USD in 1 day
(0 Reviews)
0.0
alex397

I am ready to start.

$30 USD in 0 days
(0 Reviews)
0.0
SalmanGhouri

i am Expert in Queries,

$30 USD in 0 days
(0 Reviews)
0.0
tn69kl01

Hi Please see PMB.

$30 USD in 0 days
(0 Reviews)
0.0
biprosaha1986

Hello sir, Ready to work with you. Thanks.

$30 USD in 0 days
(3 Reviews)
0.0
nimitdudani

I can do this for you

$30 USD in 0 days
(0 Reviews)
0.0
webtrode

Can have it for you in an hour or less.

$30 USD in 1 day
(0 Reviews)
0.0
arvindsaharkar

We can provide the query within 2-3 hrs.

$50 USD in 0 days
(0 Reviews)
0.0
rwolfe716

I can have this query done for you in less than a day.

$30 USD in 1 day
(0 Reviews)
0.0
tubetube

I'm a DBA. i can do this job.

$47 USD in 1 day
(0 Reviews)
0.0
abhamohunta

We are a team of developers with immense expertise and experience in PHP and MySql. We have developed several complex and extensive web applications in it. We are ranked top 15th on RAC and most of the projects done th More

$75 USD in 2 days
(0 Reviews)
0.0
premshankar110

hi, Please contact me withthe details. I have certifications in SQL and PL/SQL and can provide fast solution to your problems. Regards, prem

$75 USD in 7 days
(0 Reviews)
0.0
oper

Hello, please check PM, thanks, oper

$30 USD in 2 days
(0 Reviews)
0.0
indikas

Hi, I can write this query within a day. Regards

$30 USD in 1 day
(0 Reviews)
0.0