How to match database column with string

Question

For example, I have a table like this:

id |      name      |
--------------------
1  | T              |
2  | Text           |
3  | A              |
4  | Text1 and Text |
5  | Txt            |

, and I want to reverse match column with string, something like this:

select * from table_name where %name% like 'Text1 and Text2 and Text3'

, and to get these results:

id | name |
-----------
1  | T | 
2  | Text |
4  | Text1 and Text |

How is that posible?

Ihor Romanchenko · Accepted Answer · 2012-12-07 13:27:51Z

3

Try:

SELECT *
FROM table_name
WHERE 'Text1 and Text2 and Text3' LIKE '%'||name||'%'

UPD Here is my SQLFiddle with example: SQLFiddle.

answered Dec 7, 2012 at 13:27

Ihor Romanchenko

29k9 gold badges56 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

How to match database column with string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related