How to select a row who has a substring

I have and data like :

ID term score
1 enthusiastic 0.986
2 excellence 0.984
3 loves 0.984
4 inspirational 0.984
5 proud 0.68
6 love 0.90
7 so proud 0.71
8 so so proud 0.90

​x
 
ID term score1 enthusiastic 0.9862 excellence 0.9843 loves 0.9844 inspirational 0.9845 proud 0.686 love 0.907 so proud 0.718 so so proud 0.90​

I want to get a score whose term includes ‘proud’. I searched but can’t find anything. As you know SELECT * FROM table_name WHERE term = 'proud' will return just term who has 'proud' certainly (will return 5 proud 0.68 only). I think the problem is so easy but My mind is freeze now.

Thanks for helping

Expected Output:

5 proud 0.68
7 so proud 0.71
8 so so proud 0.90

 
5 proud 0.687 so proud 0.718 so so proud 0.90​

Answer

use like operator instead of =

SELECT * FROM table_name WHERE term like '%proud%'

 
SELECT * FROM table_name WHERE term like '%proud%'​

Advertisement

Answer