Help writing SQL query to parse data from MYSQL

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.

Kemahiran: MySQL, SQL, Pentadbiran Pangkalan Data, Pengaturcaraan Pangkalan Data

Lihat lagi: how to retrieve json data from mysql, best way to write sql queries, how to store json data in mysql using java, query parsing in sql server, sql query parsing, oracle sql parsing, parse sql query online, how to save json data in database, getafreelancer message sql query help needed, help writing sql statements software, writing sql mysql, php parse email data mysql database, sql query tree structure mysql recursive, sql query remote database mysql, sql query tree data, parse data mysql multiple php, sql query insert data child table, write sql query days data, writing sql query wordpress, need help writing sql statements

Tentang Majikan:
( 5 ulasan ) Hermitage, United States

ID Projek: #21908183

Dianugerahkan kepada:


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 Lagi

$59 USD dalam 7 hari
(3 Ulasan)

20 pekerja bebas membida secara purata $197 untuk pekerjaan ini


SQL expert. I can parse the data. I understand what you are looking for. I’ve read your project and understood. Because I’ve completed the done work before so I am sure it will not be a problem for me. I am highly pro Lagi

$190 USD dalam 7 hari
(57 Ulasan)

Hello! We are A2 Design, a Russian-Canadian web development company. Having the required skills, we will be glad to help you with your project. We have some questions for you to clear up before we start. Please m Lagi

$350 USD dalam 3 hari
(25 Ulasan)

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.

$185 USD dalam 3 hari
(46 Ulasan)

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 Lagi

$250 USD dalam sehari
(18 Ulasan)

Hello! I am a Computer Engineer with an MCSA SQL Server 2014, with 14 years of experience writing SQL. I am a near-native English speaker, currently available, and results-oriented. I can help you with your issue. Not Lagi

$150 USD dalam 2 hari
(19 Ulasan)

Dear jp57! Please check some of our Creative work [login to view URL] [login to view URL] [login to view URL] [login to view URL] Ready to build you highly professional and modern design for your website. Ready to di Lagi

$250 USD dalam 4 hari
(32 Ulasan)

Hello, How are you? I have read your description in more detail and have much interest in your project. So I think that I can finish your work perfectly as you need.I have many experiences for MySQL. If you need to di Lagi

$140 USD dalam 7 hari
(6 Ulasan)

Glad to meet you. I have checked your project description and requirements carefully. I am a senior web developer & database expert has 8+ years of good experience. I will never make you disappointed. If you give me a Lagi

$140 USD dalam 7 hari
(25 Ulasan)

Hi, Thanks for your job posting. I've read your project description carefully. You want write an SQL query to parse data from a MYSQL database for use in the wpDataTable Wordpress plugin. As a senior web developer, I h Lagi

$30 USD dalam 7 hari
(10 Ulasan)

Dear Client! I am very happy to see your project detail. I think it is just my project. :) As you can see in my profile, (my review: https://www.freelancer.com/u/kyleevert?w=f) I have much experience with your job. I t Lagi

$140 USD dalam 7 hari
(2 Ulasan)

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 Lagi

$140 USD dalam sehari
(9 Ulasan)

Hello Based review the project description enough I understood exact you needs. I have good experience in mysql database. so this project is no problem for me. I can provide perfect result in very short time. I hope t Lagi

$140 USD dalam 7 hari
(10 Ulasan)

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.

$1000 USD dalam sehari
(3 Ulasan)

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 Lagi

$100 USD dalam sehari
(10 Ulasan)

I am responsible and reliable. Always ready for new challenges as well as professional training. New technologies have always fascinated me and intrigued me. For myself, I can say that I'm moving, full of research spir Lagi

$120 USD dalam 7 hari
(4 Ulasan)

Hello, I have gone through your requirements and understand what you need. I am a Web developer with 7 years experience I have used a lot of technology to implement my clients solutions. List of Services that i can hel Lagi

$200 USD dalam 5 hari
(3 Ulasan)

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.

$77 USD dalam 2 hari
(0 Ulasan)

Hello, how are you? I am interested in your project, please write me to provide more details and verify your requirements, greetings.

$140 USD dalam 7 hari
(0 Ulasan)

Hi, how are u? I have just read your job description and I am interested in working on your project. I am a good experiences in MYSQL with 5 years. So I am very confident in your project. I usually work 30 hrs per week Lagi

$140 USD dalam 7 hari
(0 Ulasan)