Find Jobs
Hire Freelancers

Build SQL Query: Most Popular Phrases With a Variable

$30-250 USD

Cancelled
Posted over 5 years ago

$30-250 USD

Paid on delivery
I need a SQL query that will return a set of frequently used patterns / word combinations in a field, as well as the number of matches found for that pattern in the field. Any amount of text could exist before or after the pattern that's shown. I should be able to add Where clauses to the query to filter the dataset that's used for the query. Example: Table [login to view URL] has several tickets with the following phrases: can't connect to facebook website can't connect to google website can't connect to msn website Pattern that should appear in SQL results: can't connect to X website Number of matches: 3
Project ID: 17821557

About the project

25 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
25 freelancers are bidding on average $98 USD for this job
User Avatar
Hi I am a database expert with 15 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. I am not making a proposal to do this, but just trying to initiate a discussion, as I could not find an algorithm for this requirement, either using full text search or using the like operator. I wanted to know if there is any additional information available regarding this. Or is it possible to already list out a set of possible phrases like 'can't connect to % website' and then get the count of only those phrases? Otherwise even if we write some sophisticated code to implement this requirement, it will give many duplicate rows as shown below for the same example you provided Phrase Count can't connect to X website 3 can't connect to 3 connect 3 website 3 Can you please let em know if you find any further possibilities that could make this simpler. Thanks Roni
$150 USD in 3 days
5.0 (75 reviews)
6.4
6.4
User Avatar
Hello! I am a Computer Engineer, with a MCSA SQL Server 2014 certification, with 12 years of experience using SQL, queries, reports and dashboards design and construction, database management, data warehousing, and database related projects and tasks. I am a near-native English speaker, currently available, and results oriented. I am an expert SQL developer, and I've done similar requirements before, and I can finish your requirement in one full working day or less. I am located in the Central Standard Timezone (GMT -5 h) We can discuss details over chat, if you like. Thanks!
$100 USD in 1 day
4.9 (21 reviews)
5.6
5.6
User Avatar
Hi, I would like to write sql code for getting the frequently used pattern. Get in touch to discuss more. Available to start now. Regards, Manish
$100 USD in 6 days
4.9 (62 reviews)
5.4
5.4
User Avatar
Hey A SQL expert developer is here I have good advanced expertise in mySQL Queries I can help you in mysql query as per your need This is an initial bid Feel free to message me Regards
$50 USD in 0 day
4.9 (22 reviews)
4.9
4.9
User Avatar
I m a web and desktop developer with 8 years of experience in this industry ,I' m also a Database Manager,I read your project details and I understood your needs I can do what you want in the deadline just contact me and we can discuss more about the project. Update: Hello drobin you sent me but I can't respond to you , send me a chat message in this way we can discuss your project. Best Regards
$35 USD in 3 days
4.9 (11 reviews)
4.6
4.6
User Avatar
Hello I have read your project description and would like to do it for you right now. Please reply me to discuss more about the same. Thanks
$50 USD in 1 day
5.0 (4 reviews)
4.5
4.5
User Avatar
Could you please provide more information on the requirement, as to whether a stored procedure would have to be built and what is the table/fields to be queried for the match? Cheers, Ranjana
$111 USD in 3 days
5.0 (2 reviews)
2.4
2.4
User Avatar
Fullstack developer here, I can deliver what you need in 1 day or less, please provide a list of table and columns in each table. I am also expert in automating reports from database so this one will be completed as expected. Send me message if you have questions. Looking forward of working with you.
$100 USD in 1 day
4.0 (1 review)
2.9
2.9
User Avatar
Hello, Hope you are doing well. I am a web developer and I have more than five years experience in MySQL an SQL. I have checked your job description and I am okay to get this done for you. You need to return the set of frequently used patterns/word combinations in a field, and I can able to do this. I am committed to getting your job done with the best quality. Thanks Atiqur Rahman
$250 USD in 2 days
5.0 (5 reviews)
1.4
1.4
User Avatar
As per description of requirement, Sql query is to be create that search possible pattern in the filed with some clarity to user for customize use of query. I have been doing these kind of activity which are related to business intelligence technology and database like oracle,teradata and sql sever. I would like to discuss more on the projects details. So that we can have better understanding for what needs to done. It would be great to work with you and hopefully never disappoint you. I am new to this platform but not in the industry. On time delivery, proper communication and quality work are my top priority. Thanks Pramod Verma
$30 USD in 4 days
5.0 (1 review)
0.4
0.4
User Avatar
Hi Ready to give you the solution. Just send us message and take your work. If you want we can give you the solution within an hour. Let's make it start. Regards Kaushik
$40 USD in 1 day
0.0 (0 reviews)
1.5
1.5
User Avatar
Hi, I am 4.5 years experience in IT industry with with primary skill is Oracle SQL/plsql.
$166 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
It can be solved by GROUP BY clause, depending on the sql software used, can be further refined. In SQL Server, we can use LIKE with patterns.
$45 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i have 2 years experience in oracle data base i can do this job easily i hope you choose me for this one .
$40 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I like to apply for this job & will deliver this in 1 day. Thanks and regards, Pradeep Gunawardhana
$88 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I've been working with MySQL for almost 10 years. Comfortable with schema design, stored procedures and functions, and constructing fast queries.
$122 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 20 plus years of experience in SQL and would provide a high quality solution.
$45 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can provide you the solution with in 1 day
$155 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have this query ready. Let me know if you want to discuss.
$133 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I work as a PL/SQL developer for 3,5 years. I solve problems in PL/SQL code every day. I believe that the skills and experiences I have makes me an ideal candidate for the job.
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Kingwood, United States
5.0
9
Payment method verified
Member since Jul 21, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.