intersection "where LIKE" QUERY IN sql

Question

what is the syntax of sql query has intersection between 2 "where Like" condition

string command_get_pay = "select Credit 
                            from Update_Company_Credit 
                           where ( Update_Date LIKE '%" + 8 + "%'& Update_Date LIKE 18'%" + 8 + "%')";`

is this true I try it but I got exception in syntax

Why did you mark the previous question as answered: stackoverflow.com/questions/3508024/sql-like-query-syntax — OMG Ponies
– OMG Ponies, Commented Aug 18, 2010 at 2:18
because after I read it is answer I know that you can't search for string in Datetime and I try to search in integer or datetime and it worked — kartal
– kartal, Commented Aug 18, 2010 at 2:25
@OMG Ponies: There is a backtick at the end of the last line -- revision history seems to think you added it. Typo? — Thanatos
– Thanatos, Commented Aug 19, 2010 at 0:57

Thanatos · Accepted Answer · 2010-08-18 02:16:43Z

2

Do you mean:

SELECT
    Credit
FROM
    Update_Company_Credit
WHERE
    Update_Date LIKE '%" + 8 + "%'
    AND Update_Date LIKE 18'%" + 8 + "%'
;

Also, LIKE takes a string to use for search, but your second LIKE appears to be invalid... what is 18'%" + 8 + "%')"?

Edit: Oh, this is C#. Still makes no sense: how are you adding a string and an integer?

answered Aug 18, 2010 at 2:16

Thanatos

44.7k17 gold badges99 silver badges152 bronze badges

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

7 Comments

SQLMenace Over a year ago

I think he wants probably OR, because a column can't be 2 values at the same time

kartal Over a year ago

sorry 18'%" + 8 + "%')" is wrong it is only LIKE '%" + 8 + "%')"

Thanatos Over a year ago

Well, he says "intersection", which is an AND kind of operation. A LIKE '%blue%' AND LIKE '%green%' can match rows, and is different from the same statement with OR. His statements seem to follow this pattern, so, ideally, he should clarify which is intended...

Thanatos Over a year ago

@salamonti: That's a little clearer, but if this is C#, how are you adding a string and an integer?

kartal Over a year ago

normal I tried 1 'Like' condition with integer and I didn't got exception and it worked because I search in datetime type

|

SQLMenace · Accepted Answer · 2010-08-18 02:16:14Z

0

the & should be probably OR?

answered Aug 18, 2010 at 2:16

SQLMenace

136k25 gold badges212 silver badges227 bronze badges

Collectives™ on Stack Overflow

intersection "where LIKE" QUERY IN sql

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related