How can I slice a string separated by "/"?

Question

How can I slice a string that is separated by / ?

Example:

What I want is to return the first input up to the comma:

_..return the first input until the comma:.._ There is no comma but `/`. However the much much better approach is [normalization](https://www.guru99.com/database-normalization.html) instead of storing delimited lists. — B001ᛦ, Oct 14 '21 at 15:04

score 1 · Answer 1 · edited Oct 14 '21 at 15:49

1

The below statement should do the trick!

SELECT id, SUBSTRING_INDEX(column1, '/', 1) AS column1 
FROM [TableName];

edited Oct 14 '21 at 15:49

marc_s

answered Oct 14 '21 at 15:08

austdav0

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Oct 14 '21 at 16:08

score 1 · Answer 2 · answered Oct 14 '21 at 15:10

1

Welcome! As B001ᛦ said, it might not be a good idea depending on your data.

To manipulate strings, look at the String functions.

SELECT SUBSTRING_INDEX(column1, '/', 1) FROM foo;

answered Oct 14 '21 at 15:10

pyb

Bohemian · Answer 3 · 2021-10-14T16:49:47.243

-1

Use regex

SELECT
  ID,
  REGEXP_REPLACE(column1, '/.*', '')
FROM …

edited Oct 14 '21 at 16:49

answered Oct 14 '21 at 15:07

Bohemian

3 Answers3