Using Regex in mySQL query
SELECT SUBSTRING_INDEX(col, "\r\n", 1) ...


Test case:

mysql&gt; SELECT SUBSTRING_INDEX("jones, sue\r\njones, mark", "\r\n", 1);
+---------------------------------------------------------+
| SUBSTRING_INDEX("jones, sue\r\njones, mark", "\r\n", 1) |
+---------------------------------------------------------+
| jones, sue                                              |
+---------------------------------------------------------+