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