SQL query to extract part of column

Question

I have a query as below, that selects Description from table where description contains 'legal:'

At the moment it extracts everything in Description field. What I want to do is only extract 50 characters from 'legal:' keyword on.

SELECT Description
FROM Issues
WHERE
Description like '%legal:%'

Any help appreciated.

What database are you using? Do you want to output legal: as part of the 50 characters? — dcaswell
– dcaswell, Commented Sep 4, 2013 at 14:24

Kermit · Accepted Answer · 2013-09-04 14:27:06Z

6

MySQL

SELECT SUBSTRING(SUBSTRING_INDEX(Description, 'legal:', -1), 1, 50)
FROM Issues
WHERE Description LIKE '%legal:%'

See a demo

SQL Server

SELECT SUBSTRING(Description, CHARINDEX('legal:', Description) + 6, CHARINDEX('legal:', Description) + 56)
FROM Issues
WHERE Description LIKE '%legal:%'
  AND CHARINDEX('legal:', Description) > 0

See a demo

edited Sep 4, 2013 at 14:27

answered Sep 4, 2013 at 14:21

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Si8 Over a year ago

How about if I have a column type XML?

Kermit Over a year ago

@SiKni8 You should write a new question on it.

Si8 Over a year ago

Done :) ... stackoverflow.com/questions/23631837/…

Collectives™ on Stack Overflow

SQL query to extract part of column

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related