mysql - syntax error near WHERE when trying to find product with names that are different with the same assigned codes -

i have columns in table product named id , name. each row product single product code.

i retrieve names , ids of similar-sounding products different codes. know basic structure of such query should in mysql?

your last clause should having clause, not clause. using aggregate function on row-level filter.

see sql - having vs where