Query using LIKE 1

[TheConeHead]

I am trying:

"SELECT * from table where column LIKE '"+variable+"'"

It works if the variable exactly matches the column (ie name@domain.com) but not if it includes part of it (ie domain)

Shouldn't LIKE return it either way?

 

[eichmat]

You need to include the percent signs before and after the text to locate. It should be:

SELECT * from table where column LIKE '%"+variable+"%'

 

[TheConeHead]

Ahhh forgot about those... beauty - thanks man!