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
26 freelancers are bidding on average $104 for this job
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
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