finding same parts of strings values in SQL

Question

Can I find same parts of strings values in SQL? Also this parts should be more then one character. For example in in column with values

good table
excellent book
nice table
bad chair
nice magazine

It should find table and nice. I'm not sure maybe Like + Regex can help with it.

Please provide sample data, desired results, a tag for the database you are using and a clear explanation. — Gordon Linoff
– Gordon Linoff, Commented Sep 3, 2020 at 11:55
Do you know upfront what parts you are looking for? For instance do you know that you are looking for "table" specifically, or are you looking for re-occuring patterns — Sean
– Sean, Commented Sep 3, 2020 at 12:12
I understood thet explain task incorrect, so other example or this: if i have colums of emails and i want count their domains, like '[email protected]' '[email protected]' '[email protected]' '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]' and i want result table like '@gmail.com' 5 '@hotmail.com' 2 '@mail.net' 2 — Vetal Sidorenko
– Vetal Sidorenko, Commented Sep 3, 2020 at 12:38

jarlh · Accepted Answer · 2020-09-03 12:01:56Z

1

Please, read my comment to the question.

Try this:

SELECT Column1
FROM YourTable
WHERE Column1 Like '%table%' OR Column1 Like '%nice%'

This should return: good table, nice table, nice magazine

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

answered Sep 3, 2020 at 12:00

Maciej Los

8,6311 gold badge22 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1