[myoung@midsdbs02v ~]$ mysql -umyoung -mypass mirthdb -e "SELECT ARCHIVE_MESSAGE.RAW_DATA FROM ARCHIVE_MESSAGE WHERE ARCHIVE_MESSAGE.STATUS='SENT' AND AND ARCHIVE_MESSAGE.RAW_DATA NOT LIKE '%MC%' AND ARCHIVE_MESSAGE.RAW_DATA LIKE '%Reference Range:%';" > MIDSIMP-99-0002964095.txt
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ARCHIVE_MESSAGE.RAW_DATA NOT LIKE '%MC%' AND ARCHIVE_MESSAGE.RAW_DATA LIKE '' at line 1