ansaurus

Question

Answer 1

A:

You cannot parse HTML inside of SQL queries, that doesn't make any sense. Perhaps you could just maintain a special search version of the table with all the HTML stripped, but you would have to use some external processing to do that.

HeavyWave 2010-04-13 08:20:26

ok in php i get this 4 records but i need to show case only that correct record (row3) how can i do but the result come 4 records but i need to display the particular 3d result only how can i parse form PHP

Dam 2010-04-13 08:22:44

Answer 2

A:

try this solution: not tried it myself but apparently it works.

source: http://forums.mysql.com/read.php?52,177343,177985#msg-177985

   SET GLOBAL log_bin_trust_function_creators=1;
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 ;
SELECT fnStripTags('this <html>is <b>a test</b>, nothing more</html>');

KB 2010-06-07 14:40:23

or you could just have separate column/field with pre-stripped content and then use that to search for your keywords - of course that would duplicate loads of data.

KB 2010-06-07 14:47:22

ansaurus

tags:

views:

answers:

MySQL - remove HTML tags from record

related questions