Find and Replace MySQL column with substring


/ Published in: MySQL
Save to your folder(s)

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 \' )

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.