MySQL : left part of a string split by a separator string?

mysql string split separator
Dylan picture Dylan · Apr 20, 2011 · Viewed 42.8k times · Source

I need a MySQL function to get the left part of a string with variable length, before the separator.

For example, with separator string '==' :

abcdef==12345     should return abcdef
abcdefgh==12      should return abcdefgh

Also the same thing, but for the right part...

Answer

Shakti Singh picture Shakti Singh · Apr 20, 2011 
SELECT SUBSTRING_INDEX(column_name, '==', 1) FROM table ; // for left

SELECT SUBSTRING_INDEX(column_name, '==', -1) FROM table; // for right

Related questions

Split comma delimited string --> FUNCTION db.CHARINDEX does not exist

I need to split comma delimited string into a second columns I have the following table : CL1 POS POS2 LENGHT ALLELE 1 3015108,3015109 5 A 2 3015110,3015200 10 B 3 3015200,3015300 15 C 4 3015450,3015500 20 D 5 3015600,3015700 15 E I want to split the numbers after the comma into a second column POS2 …

Read More
how to convert a string to date in mysql?

I have a string column which acts as a date and I want to select it as a date. Is it possible? My sample data format would be; month/day/year -> 12/31/2011

Read More
How to use GROUP BY to concatenate strings in MySQL?

Basically the question is how to get from this: foo_id foo_name 1 A 1 B 2 C to this: foo_id foo_name 1 A B 2 C

Read More