string%
, but in a sentence "test one two three" if I use ste%
it will not return the phrase, how could I search if it contains within the sentence?
string%
, but in a sentence "test one two three" if I use ste%
it will not return the phrase, how could I search if it contains within the sentence?
Since what you want does not start with this it does not help you to do a select like ste%
because it will return everything you start with ste followed by any thing.
In order to get everything containing just this your select must have %ste%
select coluna from tabela where coluna like %ste%