Mysql where

merhaba arkadaslar su komuta arama kodu ekleyecegim

$sql = 'SELECT `player`,sum(kills) as tkills ,sum(death) as tdeath,sum(time) as ttime, sum(points) as total_points , sum(position) as tpos, sum(position = 1) as wins, count(*) as tgames, sum(position)/count(*) as avgpos,sum(kills)/sum(death) as kd FROM '.$dbprefix.'playerstats GROUP BY player ORDER BY '.$sort.' desc LIMIT '.($p*$per_page).','.$per_page;

fakat assagıdaki komutu nereye yazdıysam yazayım calısdıramadım

WHERE player='.$nick.'

yardımcu olurmusunuz

$sql = 'SELECT `player`,sum(kills) as tkills ,sum(death) as tdeath,sum(time) as ttime, sum(points) as total_points , sum(position) as tpos, sum(position = 1) as wins, count(*) as tgames, sum(position)/count(*) as avgpos,sum(kills)/sum(death) as kd FROM '.$dbprefix.' WHERE player LIKE "%'.$nick.'%" playerstats GROUP BY player ORDER BY '.$sort.' desc LIMIT '.($p*$per_page).','.$per_page;