SQL reverse LIKE

sql linq sql-server-2008-r2

You can use CHARINDEX for this.

Select * from countrywhere CHARINDEX(country.Name, 'Republic of Macedonia') > 0

sql linq sql-server-2008-r2

Just reverse the operator (and fix the syntax)

Select * from countrywhere 'Republic of Macedonia' LIKE CONCAT('%',country.Name,'%')

sql linq sql-server-2008-r2

For SQLite, a substring (mysubstring column) in a table (mytable) can be compared against an arbitrary larger test string:

select * from mytable where instr('Somewhere substring is here', mytable.mySubstring) > 0

CodeHunter