CODEWITHSUNDEEP
sql
Vetal Sidorenko
Vetal Sidorenko

Reputation: 1

finding same parts of strings values in SQL

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.

Upvotes: 0

Views: 72

Answers (1)

Maciej Los
Maciej Los

Reputation: 8591

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

More: SQL Like Operator

Upvotes: 1

Related Questions