Find Jobs
Hire Freelancers

Edit a mySQL Query that is run from a php file. Need to compare elements of comma delimited strings.

$30-250 USD

Imekamilika
Imechapishwa over 5 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa
I have a SQL table that has a column called "categories" which contains a number of 15-digit alpha-numeric codes in a comma delimited string. The categories string may look something like: "9du9p08tb7oj4ic, ol888ag4nnu13q6, paidgsyegfro807." I have a php file that takes categoryIDs, which is another comma delimited string, as a parameter. Similarly, the categoryIDs string may look like: "paidgsyegfro807, f04rpd248qgmip1." I need somebody to edit the SQL line in my php file so that, amongst other criteria which do not need to be edited, the query only returns results from the table whose category string contains at least 1 similar categoryID to those passed as a parameter in the php file. I understand storing a number of strings as one comma delimited string is not good database design, but I simply do not have the time right now to redesign the database. Both a glimpse of what the database looks like and the SQL line that is ran have been uploaded with this post so that you all have an idea of what you're working with. The $sql line is the only thing that needs to be changed in this case. There is no sensitive data that is not publicly available in this database either. I am looking to pay between $30-$50 for this project as it should be a very simple fix.
Kitambulisho cha mradi: 18402151

Kuhusu mradi

9 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Hi Sir! I'm the expert PHP, MySQL developer. you can check my profile here https://www.freelancer.com/u/FASTGuru.html .with 6 years of experience I assure you the highest quality of the work. Please discuss details in message. thank you!
$55 USD ndani ya siku 1
5.0 (236 hakiki)
8.1
8.1
9 wafanyakazi huru wana zabuni kwa wastani $121 USD kwa kazi hii
Picha ya Mtumiaji
Hello! I have read your project description but did not understand your actual requirement. Please reply me to discuss in detail. I can surely help you with this. Thanks
$50 USD ndani ya siku 3
5.0 (162 hakiki)
7.4
7.4
Picha ya Mtumiaji
Hello, I can give you the table by making the necessary changes, hope you can give me an opportunity to handle this job.
$250 USD ndani ya siku 1
5.0 (44 hakiki)
6.8
6.8
Picha ya Mtumiaji
hi there, Yes i understand you want to compare category id with single column containing multiple CSV values, i would love to work on this for you and get it done perfectly! :) Can you share existing php code with me and probably a copy/access of DB too?
$160 USD ndani ya siku 1
5.0 (101 hakiki)
6.9
6.9
Picha ya Mtumiaji
Hello. I have good skills in MySQL, PHP, SQL. I'm interest to your project. I hope to work with you. Contact me please. Thank you.
$140 USD ndani ya siku 1
4.9 (137 hakiki)
6.3
6.3
Picha ya Mtumiaji
Hey, I'm interested in your project. Please send me a message so that we can discuss more. Skills - PHP, MySQl, jQuery / Prototype, Javascript, HTML, CSS and more.
$30 USD ndani ya siku 3
4.9 (103 hakiki)
5.7
5.7
Picha ya Mtumiaji
Hi, I need to see the database structure and then I can build this query for you. If you can give me database access and the name of table to work with then I will also show you real results of the query. Let's discuss this. Looking forward to your positive response. Thanks Virat
$50 USD ndani ya siku 1
5.0 (5 hakiki)
4.8
4.8

Kuhusu mteja

Bedera ya UNITED STATES
St Louis, United States
5.0
6
Njia ya malipo imethibitishwa
Mwanachama tangu Feb 14, 2018

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.