MYSQL - REMOVE HTML TAGS from Record
- by Dam
Need help to form the MYSQL query
from table one column having the bellow content
Row1 : this is first <a href='mytext.txt'>row</a> from the table
Row 2 : THis is the second row <img src ='mytext.jpg'> my image is there
Row 3 : <p>This is the Third row my mytext is there </p>
Row 4 : <p class='te_mytext'>This is the Third row my text is there </p>
this is the table rows i try to search the keyword as 'mytext'
my query is
SELECT * from table WHERE colmn_name ` like '%mytext%' "
i will get all the 4 rows as result but the result is wrong ..... need to get the correct output as only Row 3 the reason this row only having the mytext inside the content all other are not in content but mytext having in all rows
how can i write the Query MYSQL please help me (NOT in PHP only MYSQL )