I have a text field in a SQL database that has data with html code in the format:
<br>Year - <b>title</b>, venue, city, comments
<br>2022 - <b>Heysen Prize for Landscape</b>, Hahndorf Academy, Hahndorf, SA, finalists exhibition
<br>2022 - <b>GreenWay Art Prize</b>, Art Est. Art School and Gallery, Sydney, finalists exhibition
<br>2022 - <b>Swell Sculpture Festival</b>, Currumbin, Qld, finalists exhibition
<br>2022 - <b>North Queensland Ceramic Awards</b>, Perc Tucker Regional Gallery, Queensland, finalists exhibition
and I need these parsed and placed as individual rows in another table within the db. However, there is an authority list as a table in the same db that needs to match the title (data with the <b>xxx</b> tags) reliably.
The output should match this:
id artist_id name artprizes_id year matchedTitle confidence
6589727 26487 Lea Kannar-Lichtenberger 583 2022 GreenWay Art Prize 100
6589728 26487 Lea Kannar-Lichtenberger 44 2022 Swell Sculpture Festival 100
6589729 26487 Lea Kannar-Lichtenberger 934 2022 North Queensland Ceramic Awards 100
6589730 26487 Lea Kannar-Lichtenberger 684 2022 Wyndham Art Prize 100
At the moment the first row in the source is not being matched (Heysen Prize for Landscape).
And it takes > 4hrs to process the script.
It must match the title string >99% and it should if possible process more efficiently (faster) than the current script.
I will only contact freelancers with a rating >4.8 and who accept that payment for the milestone will only be made on successful completion of the project. I will make the tables available to the successful freelancer.
Thank you for your time
35 freelancers are bidding on average $146 for this job
*** TRUE SQL GURU *** I read your full description and well understood the full requirements , i can do it perfectly with faster query execution and exact output as desired. we can talk to start , thank you
I am based in Sydney and very well versed with the scripts stored as data values. Do let me know. I am pretty much available for rest of the day and can do it in day. Thanks Jag
Hello Martin! Here is an expert who you are looking for. I have rich experience in database management and can help you with my best skills. Please contact me.
hello. i am sql expert having rich experience for 6+ years. i can improve your script. i'd like to see you on chatbox. we can discuss details. please contact me. i provide the best solution. thanks.
Hi Client, I want to help you with this. I have been working as SQL programming and make sure I will be the perfect resource for this job. Please text me so we can go further with this task.