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

1 vote286 views2 answers
Postgresql check privileges on schema
SQL
2 votes273 views1 answer
Where clause for child record apex
SQL
14 votes260 views3 answers
Sql trim from string
SQL
1 vote252 views1 answer
Mysql get latest duplicate rows
SQL
0 vote279 views1 answer
Doctors appointment
SQL
16 votes252 views4 answers
Sort by sql
SQL
31 votes271 views4 answers
Mysql grant execute
SQL
16 votes257 views2 answers
Add column if not exists mysql
SQL
4 votes244 views3 answers
Create database in mySQL
SQL
0 vote212 views1 answer
Postgres delete where id in
SQL