SELECT substring_index( wantclass, ' ', 1 ) AS wclass FROM bd_resume WHERE user_id =42
wantclass is the field name corresponding to the string to be intercepted,
' ' is the key character to use as the intercepted character
1 is the position where the key character appears
-