SQL WHERE string LIKE field

Question

I have a table tracking links structured as follows:

id
domain_name
traffic_count
enabled
created_at

Let's say I have a record with domain_name of "some-domain.com", and then let's say I want to find the record having that domain, except all I have to go by is a subdomain of that domain.

I essentially want to do this:

SELECT * FROM links 'subdomain.some-domain.com' LIKE %domain_name%"

How would I do this?

Which DB engine are you using? MySQL?

bfavaretto
– bfavaretto

2012-03-01 20:50:13 +00:00
Commented Mar 1, 2012 at 20:50 — bfavaretto
– bfavaretto, Commented Mar 1, 2012 at 20:50

RQDQ · Accepted Answer · 2012-03-01 21:05:27Z

11

Updated (thanks to Chad Johnson):

SELECT * FROM links WHERE 'subdomain.some-domain.com' LIKE CONCAT('%', domain_name, '%')

edited Mar 1, 2012 at 21:05

answered Mar 1, 2012 at 20:49

RQDQ

15.6k2 gold badges36 silver badges61 bronze badges

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

4 Comments

Kevin Bowersox Over a year ago

Shouldn't there be a where clause?

Chad Johnson Over a year ago

Very close! Looks like this works: SELECT * FROM links WHERE 'subdomain.some-domain.com' LIKE CONCAT('%', domain_name, '%')

bfavaretto Over a year ago

@ChadJohnson, yes, that's why I asked which DB. On MySQL you have to use CONCAT. Also, you need a WHERE, like SELECT * FROM links WHERE (etc).

Joachim Isaksson Over a year ago

@ChadJohnson Note of caution, this query won't be able to use indexes or even worse (as SQL Server seems to do) builds a temporary index in memory, answers the question and throws the index away. In other words, don't use on a high traffic site without testing performance thoroughly.

Collectives™ on Stack Overflow

SQL WHERE string LIKE field

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related