Đã hoàn thành

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.

Kĩ năng: MySQL, SQL, Quản trị cơ sở dữ liệu, Lập trình cơ sở dữ liệu

Xem nhiều hơn: 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

Về Bên Thuê:
( 5 nhận xét ) Hermitage, United States

ID dự án: #21908183

Được trao cho:

alexand1025

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 Thêm

$59 USD trong 7 ngày
(3 Đánh Giá)
2.0

20 freelancer đang chào giá trung bình $197 cho công việc này

iramrao

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 Thêm

$190 USD trong 7 ngày
(57 Nhận xét)
7.5
A2Design

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 Thêm

$350 USD trong 3 ngày
(25 Nhận xét)
7.3
MrMSparrow

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 trong 3 ngày
(46 Nhận xét)
6.3
idragon712

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 Thêm

$250 USD trong 1 ngày
(18 Nhận xét)
6.1
SergioAlfaroV

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 Thêm

$150 USD trong 2 ngày
(19 Nhận xét)
5.6
Friends4it

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 Thêm

$250 USD trong 4 ngày
(32 Nhận xét)
6.3
whiteeagle0001

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 Thêm

$140 USD trong 7 ngày
(6 Nhận xét)
5.3
bluebear1888

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 Thêm

$140 USD trong 7 ngày
(25 Nhận xét)
4.9
KGeorgy

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 Thêm

$30 USD trong 7 ngày
(10 Nhận xét)
4.9
kyleevert

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 Thêm

$140 USD trong 7 ngày
(2 Nhận xét)
4.9
romansokolv708

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 Thêm

$140 USD trong 1 ngày
(9 Nhận xét)
4.3
MobileKing1225

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 Thêm

$140 USD trong 7 ngày
(10 Nhận xét)
4.4
Choosearts

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 trong 1 ngày
(3 Nhận xét)
3.9
JennyHazard

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 Thêm

$100 USD trong 1 ngày
(10 Nhận xét)
3.6
avdo6

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 Thêm

$120 USD trong 7 ngày
(4 Nhận xét)
2.3
eliaa

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 Thêm

$200 USD trong 5 ngày
(3 Nhận xét)
2.2
shwetajain676

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 trong 2 ngày
(0 Nhận xét)
0.0
omgonzalez

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

$140 USD trong 7 ngày
(0 Nhận xét)
0.0
SistemasUno

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 Thêm

$140 USD trong 7 ngày
(0 Nhận xét)
0.0