Mysql Search

[hackerspk]

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'

       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 

[jmcilhinney]

You might want to try a little search first.

http://www.google.com.au/search?q=SQ...ient=firefox-a

[hackerspk]

ok thanks i found it