public class Soql_example_5 
{
    public string searchText    {set;get;}
    public string query            {set;get;}
    public List<Account> accounts        {set;get;}
    
    public void fetchData()
    {
      string query='select id, name, phone, industry from Account where name like \' % '+searchText+' % \' ';
        accounts =Database.query(query);
    }
}

-------------------------------------------------------------------------------------------

<apex:page controller="Soql_example_5">
    <apex:form id="fm">
         
        <apex:inputText value="{!searchText}"/> 
        <apex:commandButton value="Go" action="{!fetchData}" reRender="fm"/><br/><br/>
 
     <apex:pageblock>
          <apex:pageBlockSection>
            <apex:pageBlockSectionitem>
        <apex:pageBlockTable value="{!accounts}" var="a" cellpadding="50" width="2000" rules="rows" border="frame" rendered="{!NOT(ISNULL(accounts))}">
            <apex:column value="{!a.name}" headervalue="Name"/>
            <apex:column value="{!a.phone}" headervalue="Phone"/>
            <apex:column value="{!a.industry}" headervalue="Industry"/>
        </apex:pageBlockTable>
        </apex:pageBlockSectionitem>
    </apex:pageBlockSection>
            </apex:pageblock>
    </apex:form>
</apex:page>