How to search any part of the string with mysql

2
Hello, I use this form to search MySQL 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?

    
asked by anonymous 31.03.2017 / 19:31

1 answer

1

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%

    
31.03.2017 / 21:04