how to get part of col name in query. for ex:
les say i have these rows in table: id name last address 1 dave da new york 2 rand ra ohio 3 random a new
now i want to get rows where address has a word new in it.
$s=mysql_query("SELECT * FROM 'table' WHERE address ='new'");
so output should be 1st and last row.