JV - Your code, my SEO

Status
Not open for further replies.

Castamir

BANNED
Joined
Sep 4, 2019
Messages
1,200
Reaction score
1,058
How do you query a specific value from an Sql column containing multiple values, separated by comma?

Example
Let the table below represent a sql database with two columns named student and results. Results column contain two comma separated values. How can I select the "percentage" in an an Sql query?



Student | Results
---
Student 1| "marks": 12, "percentage"=2
Student 2 |"marks": 32, "percentage"=5
Student 3 |"marks": 52, "percentage"=9
If you can handle a data set for a medical students website like the above, please dm. In return, I will improve your rankings by at least 10 spots in 5 days or less.
 
This is rough but would get the job done.. replace(replace(right(results,3),'"',''),'=','')
On my phone so may have messed up the syntax but the idea is take the last 3 digits of the results field assuming this will be either "=1 up to 100. Then wrap with replace to pull out the unwanted double quote and equals.

Hoping I didn't get the wrong end of the stick here feel free to message me if you need help.
 
Please, I'm looking for someone who can do it directly on my server because the sql table I posted above is just an example
 
Please, I'm looking for someone who can do it directly on my server because the sql table I posted above is just an example
You will have a better success finding someone moving this thread to HAF since it is not a JV thread, your just paying with your SEO service instead of cash.
 
You will have a better success finding someone moving this thread to HAF since it is not a JV thread, your just paying with your SEO service instead of cash.
Yeah, I've already got someone on it.
 
Status
Not open for further replies.
Back
Top