Generally... Wouldn't grouping by an id (which is normally unique) have no real benefit... Except some strange behaviour? Just to clarify: Why aren't you sticking to the LIMIT 1? 2012/2/7 <admin@xxxxxxxxxxxxxxxxxxx> > I have been struggling with this issue for an hour and honestly I am not > sure why. > > I consider myself to be pretty savvy with MySQL but I am running into an > syntax error that is just flat out eluding me. > > > > $query = "SELECT `table2`.`name` from `table1` ,`table2` WHERE > `table2`.`user_id`=`table1`.`seller_id` AND IF(`table2`.`name`='juice','No > Juice for YOU', `table2`.`name`=`table2`.`name`) LIMIT 1"; > > This query works!! > > > > But If I try to add a GROUP BY to the query, complete failure. > > $query = "SELECT `table2`.`name` FROM `table1` ,`table2` WHERE > `table2`.`user_id`=`table1`.`seller_id` AND IF(`table2`.`name`='juice','No > Juice for YOU', `table2`.`name`=`table2`.`name`) GROUP BY `table1`.`ID` > LIMIT 1"; > > > > The main goal here is to get only 1 return but MySQL is returning the same > row 2 times. > > Before I beat my head in anymore I will toss this out to you guys and beat > myself up later for not drinking enough coffee or something . > > > > > > > > > >
