nickwshaw
8/10/2014 - 1:34 PM

Select a substring from a textfield

Select a substring from a textfield

new_gist_file.sql
content_copyfile_download
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(transaction, '0', -1), '.', 1) FROM somedb.refunds;