Remove html tags in MYSQL/SQL database query.

I am facing a serious problem in mysql query while sorting a column in database. If i am sorting a column of table having rows with and with out html tags then i am not getting correct sorting order due to html tags added before some of the text Like below :-

Solutions :  To prevent this problem we need first to ignore html tags and then run sorting query to perform sorting operation. But the question is how we can do this. After alot of troubling and googling finally i find out the sollution. Here is a sql function which will solve my problem and ofcouse your also. 

Method of users :-

Step 1 - First of all you need to run below function in your sql/mysql database. Just copy and paste into your database.

DROP FUNCTION IF EXISTS fnStripTags;
DELIMITER |
CREATE FUNCTION fnStripTags( Dirty varchar(4000) )
RETURNS varchar(4000)
DETERMINISTIC 
BEGIN
  DECLARE iStart, iEnd, iLength int;
    WHILE Locate( '<', Dirty ) > 0 And Locate( '>', Dirty, Locate( '<', Dirty )) > 0 DO
      BEGIN
        SET iStart = Locate( '<', Dirty ), iEnd = Locate( '>', Dirty, Locate('<', Dirty ));
        SET iLength = ( iEnd - iStart) + 1;
        IF iLength > 0 THEN
          BEGIN
            SET Dirty = Insert( Dirty, iStart, iLength, '');
          END;
        END IF;
      END;
    END WHILE;
    RETURN Dirty;
END;
|
DELIMITER ;

Step 2 - Now we need to call the above function in our query like below "SELECT fnStripTags(message) FROM notes ORDER BY message desc"   

Chears..
Happy Coding :)