hwoarang69 Newbie Poster 597 posts since Feb 2012 Reputation Points: 11 [?] Q&As Helped to Solve: 0 [?] Skill Endorsements: 11 [?] •Community Member 0 2 Years Ago 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.