What is the mysql syntax to ONLY select the very first word of a certian field in a query?
http://dev.mysql.com/doc/mysql/en/String_functions.html try that you will probably need to use SUBSTRING, as well as maybe LOCATE