Select the first word in a text field - MySQL Snipplr Social Repository

Revision: 24296

at February 25, 2010 11:31 by jpkunst

Initial Code

SELECT IF(INSTR( `textfield`, ' ' ) > 0, SUBSTRING( `textfield` FROM 1 FOR (INSTR( `textfield`, ' ' ) -1 )), `textfield`) FROM `exampletable`;

Initial URL

Initial Description

Initial Title

Select the first word in a text field

Initial Tags

Initial Language

MySQL