MYSQL - how to string comparisons and query? -
+--------------------+---------------+------+-----+---------+-------+ | id | gkey |goods | pri | country | | +--------------------+---------------+------+-----+---------+-------+ | 1 | book-1 | 1 | 10 | | | | 2 | phone-1 | 2 | 12 | | | | 3 | book-2 | 1 | 13 | | | | 4 | book-3 | 1 | 10 | | | | 5 | phone-2 | 2 | 10 | | | | 6 | phone-3 | 2 | 20 | | | | 7 | book-10 | 2 | 20 | | | | 8 | book-11 | 2 | 20 | | | | 9 | book-20 | 2 | 20 | | | | 10 | book-21 | 2 | 20 | | | | 11 | phone-30 | 2 | 20 | | | +--------------------+...