part of url in where clause in sql

Question

I have to put part of url in select query like

select* 
from tbl_name 
where column_name1 like employee 
   and column_name like questions;

there is a column name col_url and in that there are many site url but i have select those url which contain particular word likewise in this url of stackflow it is questions.

How can i do this i have written query above for example purpose .

How can I create a blank/hardcoded column in a sql query?

i want to filter the table based on part of url like you see the url it have many word separated by backslash so i need to filter the based on that word only how can i do that — codingforeveryone, Feb 25 '16 at 09:05
Please edit your question and show me a real sample (your value in db and the result you need) — ScaisEdge, Feb 25 '16 at 09:08

score 0 · Answer 1 · edited Feb 25 '16 at 15:08

0

I think the answer you expecting is this

SELECT * 
FROM tbl_name 
WHERE column_name1 LIKE employee 
   AND column_name LIKE questions
   AND col_url LIKE ('%select REPLACE(''col_url'',''\'','''')%')

edited Feb 25 '16 at 15:08

Qirel

25,449
7
45
62

answered Feb 25 '16 at 11:57

New

675
1
11
21

part of url in where clause in sql

1 Answers1