I have this table in SQL Server 2012:
Id INT
DomainName NVARCHAR(150)
And the table have these DomainName values
And this value:
mail.othersite.com
and I need to select the rows where the string ends with the column value, for this value I need to get the row no.3 othersite.com
It's something like this:
DomainName Like '%value'
but in reverse ...
'value' Like %DomainName
You can use such query:
SELECT * FROM TABLE1
WHERE 'value' LIKE '%' + DomainName
WHERE 'value' LIKE '%' || DomainNameIt works on mysql server. [ LIKE '%' || value ] not works great because when value start with numbers this like not return true.
SELECT * FROM TABLE1 WHERE DomainName like CONCAT('%', value)
In Oracle you can use REGEXP_LIKE string function for string start/ends with search. This function 1st argument is an expression/source string and 2nd argument is a pattern/search string. Use dollar $ for a ends with value and ^ for starts with value. For example
select * from TABLE1 where REGEXP_LIKE(DomainName, :value ||'$');
If you have a OR condition between different values, then use following pipe | syntax.
select * from TABLE1 where REGEXP_LIKE(DomainName, 'value1$|value2$|value2$');
Refer this link for more info on REGEXP_LIKE string function
one possible answer could be
SELECT patient_id,first_name from patients where first_name like 'S%s'
