Build SQL Query: Most Popular Phrases With a Variable

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.


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

Kemahiran: SQL

Lihat lagi: sql query tree structure records, asterisk call forward database sql query, sql query child child, sql select first record, top 10 sql queries, sql: selecting rows where column value changed from previous row, select max over partition by sql server, tableau initial sql select, how to get previous row value in sql, sql select single row, select number of rows sql, sql query tree children, getafreelancer message sql query help needed, specialise sql query, sql query find number child elements, design sql query forum tree, simple sql query creator, sql query parent level, questions sql query oracle 10g, freelance sql query

Tentang Majikan:
( 5 ulasan ) Kingwood, United States

ID Projek: #17821557

26 pekerja bebas membida secara purata $104 untuk pekerjaan ini


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 Lagi

$150 USD dalam 3 hari
(59 Ulasan)

SQL in not designed for these types of problems, it is better to do it with C# or any other language. However, I can do it on SQL which will be much complex. I can use string matching algorithms like "Cosine simi Lagi

$200 USD dalam 5 hari
(31 Ulasan)

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 dalam 6 hari
(48 Ulasan)

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 dat Lagi

$100 USD dalam sehari
(11 Ulasan)

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 dalam 0 hari
(11 Ulasan)
$111 USD dalam 3 hari
(8 Ulasan)

Hi I have excellent database design skills. Based on your requirements, I can create an elegant solution for you. I might use stored procedures to create your query, but we will based on our initial discussion Lagi

$250 USD dalam 3 hari
(1 Ulasan)

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 ex Lagi

$100 USD dalam sehari
(1 Ulasan)

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 dalam 3 hari
(2 Ulasan)

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 dalam sehari
(3 Ulasan)

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 retu Lagi

$250 USD dalam 2 hari
(5 Ulasan)

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 Lagi

$30 USD dalam 4 hari
(1 Ulasan)

I have 20 plus years of experience in SQL and would provide a high quality solution.

$45 USD dalam 3 hari
(0 Ulasan)

I can provide you the solution with in 1 day

$155 USD dalam sehari
(0 Ulasan)

I've been working with MySQL for almost 10 years. Comfortable with schema design, stored procedures and functions, and constructing fast queries.

$122 USD dalam 3 hari
(0 Ulasan)

I have this query ready. Let me know if you want to discuss.

$133 USD dalam sehari
(0 Ulasan)
$88 USD dalam sehari
(0 Ulasan)

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 Lagi

$35 USD dalam 3 hari
(0 Ulasan)

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 dalam 2 hari
(0 Ulasan)

Hi, I like to apply for this job & will deliver this in 1 day. Thanks and regards, Pradeep Gunawardhana

$88 USD dalam sehari
(0 Ulasan)