record 1 ==> [font color=red]This is example 1[/font]
record 2 ==> This is not red text.
Now I use normal code for searching like ..
$result=mysql_query("SELECT * FROM table_name WHERE column_name LIKE '%red%'");
The problem with it is that, if I search for "red", it results both the records. But I don't want record 1 to be included in the result. So is there any way to exclude those BB CODE (or HTML code) while using SELECT command?