I have a database with the table houses with field names: 'doors', 'windows' and 'roofs'.

The data (fields) under 'windows' contains multiple entries divided by a comma, like this
round,blue
round,red
round,brown
square,blue
square,red
square,brown

People can fill in a keyword to search for with this form

<form action="insert.php" method="post">
Search windows -> Keyword: <input type="text" name="keyword1"><br>
<input type="Submit">
</form> 

And insert.php is this

<?php
$username="root";
$password="";
$database="houssss";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM houses WHERE windows='keyword1'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Value1</font></th>
<th><font face="Arial, Helvetica, sans-serif">Value2</font></th>
<th><font face="Arial, Helvetica, sans-serif">Value3</font></th>
<th><font face="Arial, Helvetica, sans-serif">Value4</font></th>
<th><font face="Arial, Helvetica, sans-serif">Value5</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"Shrt_Desc");

?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>

</tr>

<?php
$i++;
}
?>

You guess it already, it's not working. I am struggling with this part

$query="SELECT * FROM houses WHERE windows='keyword1'";

How can I select those entries that matches the keyword?