Snipplr http://snipplr.com/language/mysql/tags/substring Recent snippets posted on Snipplr.com en-us Fri, 24 May 2013 23:52:38 GMT (MySQL) Find and Replace MySQL column with substring - jgomez http://snipplr.com/view/64199/find-and-replace-mysql-column-with-substring/ Example: There is a table, 'user', with a column, 'clear', containing values such as: `clear -------- \'animal\' \'pass'\ ` and we would like to retrieve 'animal' and 'pass' ( without the pre & post \' )

]]> Wed, 28 Mar 2012 22:00:49 GMT http://snipplr.com/view/64199/find-and-replace-mysql-column-with-substring/ (MySQL) select first character of second word (surname) - ReeceMarsland http://snipplr.com/view/25209/select-first-character-of-second-word-surname/

]]> Tue, 22 Dec 2009 03:48:08 GMT http://snipplr.com/view/25209/select-first-character-of-second-word-surname/