I'm using Solr. I have to search individuals records that also matches partly using the provided text

the functionality ought to be like the sql query

like %text%

the way I actually do this?

I solved my problem...

simply I have to use *text*

Thanks all

You should look at using n-gram analysis rather than asteriks. It's slow in comparison to n-gram. Have a look at, N-Gram Tokenizer

Thanks zinan.yumak

Used to do it again inside your way

<fieldType name="text_en" class="solr.TextField" positionIncrementGap="100">

    <analyzer type="index">
        <tokenizer class="solr.StandardTokenizerFactory" />
        <filter class="solr.StandardFilterFactory"/>
        <filter class="solr.SynonymFilterFactory" synonyms="index_immo_synonyms_en.txt" ignoreCase="true" expand="true" />
        <filter class="solr.WordDelimiterFilterFactory" generateWordParts="1" generateNumberParts="1" catenateWords="1"
            catenateNumbers="1" catenateAll="0" splitOnCaseChange="1" />
        <filter class="solr.LowerCaseFilterFactory"/>
        <filter class="solr.StopFilterFactory" ignoreCase="true" words="immo_stopwords_en.txt" />
        <filter class="solr.SnowballPorterFilterFactory" language="English"  protected="protwords_en.txt"/>
        <filter class="solr.RemoveDuplicatesTokenFilterFactory"/>
    </analyzer>

    <analyzer type="query">
        <tokenizer class="solr.WhitespaceTokenizerFactory" />
        <filter class="solr.StandardFilterFactory"/>
        <!-- we only use synonyms at index time <filter class="solr.SynonymFilterFactory" synonyms="index_immo_synonyms_en.txt"
             ignoreCase="true" expand="true"/>. Having expand="false" at query time, all equivalent synonyms will be reduced
             to the first in the list -->
        <filter class="solr.SynonymFilterFactory" synonyms="query_immo_synonyms_en.txt" ignoreCase="true" expand="false" />
        <filter class="solr.WordDelimiterFilterFactory" generateWordParts="1" generateNumberParts="1" catenateWords="0"
            catenateNumbers="0" catenateAll="0" splitOnCaseChange="1" />
        <filter class="solr.LowerCaseFilterFactory"/>
        <filter class="solr.StopFilterFactory" ignoreCase="true" words="immo_stopwords_en.txt" />
        <filter class="solr.SnowballPorterFilterFactory" language="English"  protected="protwords_en.txt"/>
        <filter class="solr.RemoveDuplicatesTokenFilterFactory"/>
    </analyzer>
</fieldType>

And employ this kind type towards the fields