iam making a dictionary program and it need a search function iam using this query
SELECT * FROM tbltel WHERE Fname='search'
but this need exact phrase but want seach for any word from database.
i also try this but it is also not working
SELECT * FROM tbltel WHERE Fname like 'search'


PHP Code:
       Try
            
Dim dbConn As OleDbConnection
            Dim dbCommand 
As New OleDbCommand()
            
Dim strPath As String

            strPath 
patH
            dbConn 
= New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" _
                                    
"DATA SOURCE=" _
                                    
strPath)
  
dbCommand.CommandText "SELECT * FROM tbltel WHERE Fname like " _
                                  
"'" ListBox1.Text "'"
            
dbCommand.Connection dbConn
            dbConn
.Open()
            
Dim dbDR As OleDb.OleDbDataReader dbCommand.ExecuteReader

            
While dbDR.Read
                rtword
.Text dbDR("Name".ToString)
                
rtresult.Text dbDR("data".ToString)
                
ToolStripStatusLabel2.Text dbDR("ID".ToString)
            
End While

            
dbConn.Close()



        Catch 
err As System.Exception
            MsgBox
(err.Message)
        
End Try