Queries using LIKE wildcards on sql server

Question

I want to do a small SQL server search in my ASP.NET web project, my database is small, so I think it's better not to use full-text search I want to do a simple search, for example:

select * from mytable where columnA LIKE '%something%' 

I can use = as follows:

 select * from mytable where columnA='"+myVariable+"' 

but how can I use a variable instead of %something% in a LIKE phrase? it is right? LIKE '"+%myVariable%+"'

I am using VS2010, C #

thanks

Answer 1

Using:

 where columnA LIKE '%' + myVariable + '%' 

Answer 2

 WHERE columnName LIKE '%' + myVarCharVariable +'%' 

Answer 3

Try this query:

 select * from tablename where colname like '%' + @varname + '%' 

Hope this helps.

Answer 4

I just tried this and found what you can do as shown below:

 SELECT * FROM whatever WHERE column LIKE '%' +@var +'%' 

Answer 5

 DECLARE @myVariable varchar(MAX) SET @myVariable = 'WhatYouAreLookingFor' SELECT * FROM mytable WHERE columnA LIKE '%' + @myVariable + '%' 

Answer 6

In case someone else stumbles upon this post, like me. In SSMS 2012 with SQL 2012 Server feedback, I was able to use the code without problems as follows.

 Declare @MyVariable Set @MyVariable = '%DesiredString%' Select * From Table_A Where Field_A like @MyVariable 

Then, every time you want to change the desired line, just change it in the Set statement.

I know that this post was made before 2012, so I mention it if someone with a newer installation is watching this post.

Answer 7

Ok, you could do something like:

 var query = "SELECT * FROM MyTable WHERE columnA LIKE '%" + myVariable + "%'";