Let's say, I have 2 product names: dead space and dead space limited edition, and I want to group them by "product_name" to select "dead space" in a mysql query. So I want the query to select the "product_name" with the shortest string if the where caluse is "product_name LIKE '%dead space%'".
Thanks a lot,