jpkunst on 02/25/10
Last Edited at 02/25/10 11:31am
SELECT IF(INSTR( `textfield`, ' ' ) > 0, SUBSTRING( `textfield` FROM 1 FOR (INSTR( `textfield`, ' ' ) -1 )), `textfield`) FROM `exampletable`;
Report this snippet Tweet
Comment:
You need to login to post a comment.