/SQL/Check if string contains substring sql

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

Check if string contains substring sql

SELECT * FROM [table]

WHERE [field] LIKE  concat ('%',[fieldname],'%')

Similar codes

8 votes349 views1 answer
How to check mysql version in xampp
SQL
2 votes368 views2 answers
Create table mysql integer NOT null
SQL
0 vote339 views1 answer
Get current date data in mysql
SQL
1 vote321 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
10 votes325 views2 answers
Sql rtrim
SQL
0 vote353 views1 answer
Procedure excute monthly oracle
SQL
0 vote319 views1 answer
How to print out column name differently in mysql
SQL
0 vote332 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
5 votes326 views1 answer
Find table from column name in sql
SQL
5 votes319 views2 answers
Mysql drop table cascade
SQL