Sql select rows containing part of string

Question

I want to write a comparation procedure (t-sql) for site seo.

I have a table with field 'url' (nvarchar()) that contain a part of site url's. Ex: 'mysyte.com/?id=2'. Also this table for each url contains metadata, that i need to extract.

The main problem is that full url on site looks like 'mysyte.com/?id=2&region=0&page=1', and i just need to ignore everething, except url in table:

I mean: 'mysyte.com/?id=2' => is a part of 'mysyte.com/?id=2&region=0&page=1'

Josh Correia · Accepted Answer · 2022-03-11 18:10:45Z

87

You can use the LIKE operator to compare the content of a T-SQL string, e.g.

SELECT * FROM [table] WHERE [field] LIKE '%stringtosearchfor%'

The percent character '%' is a wild card- in this case it says return any records where [field] at least contains the value "stringtosearchfor".

edited Mar 11, 2022 at 18:10

Josh Correia

4,4103 gold badges42 silver badges67 bronze badges

answered Apr 12, 2010 at 11:23

WiseGuyEh

19.1k1 gold badge23 silver badges21 bronze badges

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

2 Comments

tschwab Over a year ago

To search for a string that begins with a certain prefix, you can do LIKE 'prefix%'

chaoskreator Over a year ago

What about if the haystack may or may not start with the needle? Any difference then?

Jonathan · Accepted Answer · 2010-04-12 11:23:34Z

7

SELECT *
FROM myTable
WHERE URL = LEFT('mysyte.com/?id=2&region=0&page=1', LEN(URL))

Or use CHARINDEX http://msdn.microsoft.com/en-us/library/aa258228(v=SQL.80).aspx

answered Apr 12, 2010 at 11:23

Jonathan

6,0031 gold badge30 silver badges35 bronze badges

Comments

chris · Accepted Answer · 2010-04-12 11:23:46Z

6

you can use CHARINDEX in t-sql.

select * from table where CHARINDEX(url, 'http://url.com/url?url...') > 0

answered Apr 12, 2010 at 11:23

chris

10.1k1 gold badge29 silver badges27 bronze badges

Collectives™ on Stack Overflow

Sql select rows containing part of string

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related