how do i use regex in a query to find fields with only one comma? like.. ("Smith, John") but not ("apples, oranges, red")
SELECT FROM mytable WHERE myfield REGEXP "[[:alnum:]], [[:alnum:]]*$"