like command in sql query

Question

I have a column that contains the value: "Mandatory info on model l_90 with features games_14. Please provide the info for this model.[server=stack3_112] "

i want to run only the first part, "Mandatory info on model l_90 with features games_14" and exclude "Please provide info for this model" from the result.

I tried

model like '% Mandatory info on model l_90 with features games_14%'

in the select but it didn't give me what I wanted.

Tag the dbms product you use, you've already got product specific answers... — jarlh
– jarlh, Commented Oct 22, 2015 at 6:25
Should "Please provide info for this model" removed from all rows? (No matter if model l_90 is mentioned.) — jarlh
– jarlh, Commented Oct 22, 2015 at 6:28

danjuggler · Accepted Answer · 2015-10-22 00:15:27Z

1

I believe you are asking how to have only part of this column returned in your query. See:

select substr(your_column, 1, INSTR(your_column, 'Please'))
  from table
where your_column like '%Mandatory info on model l_90 with features games_14%'

This will give you a substring of everything up until the first point it finds "Please".

Note: I'm not sure what dbms you are on but the above select will work in Oracle.

answered Oct 22, 2015 at 0:15

danjuggler

1,3402 gold badges21 silver badges40 bronze badges

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

2 Comments

user5473546 Over a year ago

Hi Daniel thank you it works fine now iam able to get the expected results

danjuggler Over a year ago

Great! Please mark this as the answer to your question so others will see this as the answer if they also have the same question.

jarlh · Accepted Answer · 2015-10-22 06:24:02Z

1

WHERE {column name} like '% Mandatory info on model I_90 with features games_14%
AND {column name} NOT LIKE '%Please%')

Could this work?

This way any text that contains 'please' should be filtered out

edited Oct 22, 2015 at 6:24

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

answered Oct 21, 2015 at 22:29

drzounds

3793 silver badges19 bronze badges

2 Comments

user5473546 Over a year ago

Thanks drzounds for your answer i tried but giving zero records

user5473546 Over a year ago

drzounds your answer helps me to work on this . i appreciate your assistance thank you

Serif Emek · Accepted Answer · 2015-10-21 22:32:05Z

0

select 'Mandatory info on model l_90 with features games_14'
from table
where column like '%Mandatory info on model l_90 with features games_14%'

answered Oct 21, 2015 at 22:32

Serif Emek

6745 silver badges13 bronze badges

Collectives™ on Stack Overflow

like command in sql query

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related