MySql Full Text searches
You must create a table that uses the MyISAM engine to support full text searches in MySql. Here is an example on how to create the table.
conn = New MySqlConnection(strConn)
conn.Open()
Dim sbCmd As New System.Text.StringBuilder
sbCmd.Append("Create Table If Not Exists MyBlog ")
sbCmd.Append("(PostDate DateTime NOT NULL PRIMARY KEY, ")
sbCmd.Append("BlogEntry Text, FullText(BlogText))")
sbCmd.Append(" Engine = MyISAM")
cmd = New MySqlCommand(sbCmd.ToString, conn)
cmd.ExecuteNonQuery()
conn.Close()
Use the MySql Match Against query to preform a full text search
Match Against Query Info