How to check whether a VARCHAR column contains a substring of string?

Asked Feb 10 '20 at 07:50

Active Feb 10 '20 at 08:07

Viewed 42 times

Given a mainstring, How can I check that a column, c, in my database, contains substring of given string?

statement like ...c LIKE %mainstring% won't do the work because it will check if mainstring itself is a substring of c. I want to check whether a substring of mainstring is a substring of c.

How can I achieve that in sql?

EDIT: Given mainstring consists of words separated by ' ' I want to check if c contains any of these words (complete word) - at least one of them.

edited Feb 10 '20 at 08:07

Your Common Sense

156,878
40
214
345

asked Feb 10 '20 at 07:50

J HAED

1

Define substring. – jarlh Feb 10 '20 at 07:51
No idea how long your strings are but I would write a procedure to check all substring s of `mainstring` against all substrings of current column `c`. – nice_dev Feb 10 '20 at 07:54
I'm pretty sure there's strpos equivalent in sql ;-) – Pierre Feb 10 '20 at 07:54
For your case, `Find_in_set` looks useful. – nice_dev Feb 10 '20 at 08:08

How to check whether a VARCHAR column contains a substring of string?

0 Answers0