hi
i just attempted to put up the data in the database as u told and
tried to get the row from the database that matches the specified string within the data in each row
sorry i don't got a solution through a query but
we may use php functions as shown below
$query="select towns, events from table";
$result=mysql_query($query) or die("Couldn't execute query :".mysql_error());
while($row=mysql_fetch_array($result))
{
$value="delhi";
if(strchr($row['data_value'],"delhi"))
{
echo $row['data_value'];
echo "-----------Match Found!!<br>";
}
else
{
echo "-----------No Match Found!!<br>";
}
we may fetch the value of string to be matched from the previous form (here i use "delhi") and further match accordingly
and perform further functions after it gets matched as per requirement
instead of just echo it
sorry if i misunderstood it