We're stuck in development and need some quick help.
We're working on writing an SQL query to parse data from a MYSQL database for use in the wpDataTable Wordpress plugin.
Specifically, we're stuck on how to remove house and unit numbers from an address string while keeping street names (some of which contain numerics) intact.
Examples from the LOCATION column of a table:
123 6th Street
BUILDING NAME 345 8th Street
832 Hopeless Street
732 1st Avenue Unit 12
466 BUILDING NAME 2nd Street Unit 8
832 BUILDING NAME 5th Ave 15
In each case, we want to keep 6th Street, 8th Street, 1st Avenue, 2nd Street, etc. etc. respectively, while removing all other numbers to provide some level of anonymity for publishing.
We suspect the easiest way to go about this is to remove all substrings separated by spaces which contain a number not accompanied by a letter, but are unsure how to go about it.
This has to be done as part of the SQL query and not as a function in some other script etc.
We basically need someone how knows more about writing SQL queries than we do to help us over this hurdle, and suspect someone with more in-depth knowledge should be able to get this done in a matter of minutes.
Hi, ⭐ I have read your project description carefully and I can do this job successfully and quickly. I have much experience in MySQL and I can say that's exactly what I specialize in. I am ready to start work immediate Daha Fazla
Bu iş için 20 freelancer ortalamada $197 teklif veriyor
Hello, My name is Michalis and I am an experienced web developer. I can help you construct the SQL query in order to extract the data needed. Please contact me to get started on this.
Hello. How are you? I am a senior SQL Query expert and have rich experiences for 10+ years. After reading your proposal carefully, I have the confidence to do the things that you want. I have researched your proposal i Daha Fazla
Perfect job posting! How are you, dear? Here is SQL expert you are looking for. If you contact me, then I'm sure you can save your time. I can start right now and fulfill your aim perfectly in a short time. Waiting her Daha Fazla
Hello, Thanks for reviewing our bid, We are great on creating word press website, We got a big portfolio of our clients, Please message so we can send you the PDF portfolio regarding the work.. I am great at wordpress.
Hello, I have read your requirements and understand what you want to do. You want to remove all substrings separated by spaces which contain a number not accompanied by a letter. This task needs excellent skills about Daha Fazla
Hi, I can help you to construct SQL query which will help in seperating numbers from street name. I have 5 years of experience in SQL and PLSQL.