Sql where contains part of string

Sql where contains

SELECT * FROM mytable
WHERE column1 LIKE '%word1%'
   OR column1 LIKE '%word2%'
   OR column1 LIKE '%word3%'

Source: stackoverflow.com

Check if string contains substring sql

Declare @mainString nvarchar(100)='Amit Kumar Yadav'  
---Check here @mainString contains Amit or not, if it contains then retrun greater than 0 then print Find otherwise Not Find  
if CHARINDEX('Amit',@mainString) > 0   
begin  
   select 'Find' As Result  
end  
else  
    select 'Not Find' As Result

Sql where contains part of string

-- To find an exact string
SELECT * FROM [table] WHERE [field] LIKE '%stringtosearchfor%'.

Source: stackoverflow.com

Similar codes

0 vote123 views1 answer
Sql select rows with simlar names
SQL
0 vote176 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
15 votes182 views5 answers
If null mysql
SQL
0 vote193 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote168 views1 answer
Mysql money value
SQL
1 vote188 views1 answer
Date in where on datetime column clause mysql
SQL
1 vote180 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote184 views1 answer
Mysql get only the field names in a table
SQL
5 votes210 views3 answers
Sql limit offset
SQL
-1 vote167 views1 answer
How to dump .csv file into mysql
SQL