http://snipplr.com/users/jgomez/tags/String Recent snippets posted on Snipplr.com en-us Wed, 19 Jun 2013 14:36:04 GMT 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/