“Like” operator in inner join in SQL [on hold]











up vote
-3
down vote

favorite












SELECT COUNT(comment_id) 

FROM tbl_comment c  

WHERE superior_id LIKE '%' + account_id + '%' 

AND 'account_id' NOT IN (

    SELECT superior_id 

    FROM tbl_comment_reply 

    WHERE comment_id=c.comment_id;


this query returned error like




Query : SELECT COUNT(comment_id) FROM tbl_comment c WHERE superior_id LIKE '%' + account_id + '%' AND 'account_id' NOT IN (SELECT super...
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ account_id + '%' AND 'account_id' NOT IN (SELECT superior_id FROM tbl_comment_' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000







mysql sql







share|improve this question









New contributor




athulya is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as off-topic by Barbaros Özhan, Joakim Danielson, Madhur Bhaiya, mickmackusa, AdrianHHH 18 hours ago


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "This question was caused by a problem that can no longer be reproduced or a simple typographical error. While similar questions may be on-topic here, this one was resolved in a manner unlikely to help future readers. This can often be avoided by identifying and closely inspecting the shortest program necessary to reproduce the problem before posting." – Barbaros Özhan, Joakim Danielson, Madhur Bhaiya, mickmackusa, AdrianHHH

If this question can be reworded to fit the rules in the help center, please edit the question.









  • 1




    There's no joins in that... why do you mention one in your title? (PS: Count your parenthesis).
    – Shawn
    18 hours ago






  • 2




    You have a bracket missing from your SQL - was that accidental copy paste error or is it missing from the original?
    – slugster
    18 hours ago










  • Did you really intend to check the literal string 'account_id' for being in a list of values, or did you intend to check the contents of the account_id column?
    – Caius Jard
    17 hours ago










  • account_id used at like operator is variable?
    – DPS
    17 hours ago






  • 1




    MySQL doesn't have a concat operater (|| in Standard SQL, + in SQL Server), it's using concat instead: 'concat(%', account_id, '%'). And AND 'account_id' should be AND account_id without quotes
    – dnoeth
    16 hours ago

















up vote
-3
down vote

favorite












SELECT COUNT(comment_id) 

FROM tbl_comment c  

WHERE superior_id LIKE '%' + account_id + '%' 

AND 'account_id' NOT IN (

    SELECT superior_id 

    FROM tbl_comment_reply 

    WHERE comment_id=c.comment_id;


this query returned error like




Query : SELECT COUNT(comment_id) FROM tbl_comment c WHERE superior_id LIKE '%' + account_id + '%' AND 'account_id' NOT IN (SELECT super...
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ account_id + '%' AND 'account_id' NOT IN (SELECT superior_id FROM tbl_comment_' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000







mysql sql







share|improve this question









New contributor




athulya is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as off-topic by Barbaros Özhan, Joakim Danielson, Madhur Bhaiya, mickmackusa, AdrianHHH 18 hours ago


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "This question was caused by a problem that can no longer be reproduced or a simple typographical error. While similar questions may be on-topic here, this one was resolved in a manner unlikely to help future readers. This can often be avoided by identifying and closely inspecting the shortest program necessary to reproduce the problem before posting." – Barbaros Özhan, Joakim Danielson, Madhur Bhaiya, mickmackusa, AdrianHHH

If this question can be reworded to fit the rules in the help center, please edit the question.









  • 1




    There's no joins in that... why do you mention one in your title? (PS: Count your parenthesis).
    – Shawn
    18 hours ago






  • 2




    You have a bracket missing from your SQL - was that accidental copy paste error or is it missing from the original?
    – slugster
    18 hours ago










  • Did you really intend to check the literal string 'account_id' for being in a list of values, or did you intend to check the contents of the account_id column?
    – Caius Jard
    17 hours ago










  • account_id used at like operator is variable?
    – DPS
    17 hours ago






  • 1




    MySQL doesn't have a concat operater (|| in Standard SQL, + in SQL Server), it's using concat instead: 'concat(%', account_id, '%'). And AND 'account_id' should be AND account_id without quotes
    – dnoeth
    16 hours ago















up vote
-3
down vote

favorite









up vote
-3
down vote

favorite











SELECT COUNT(comment_id) 

FROM tbl_comment c  

WHERE superior_id LIKE '%' + account_id + '%' 

AND 'account_id' NOT IN (

    SELECT superior_id 

    FROM tbl_comment_reply 

    WHERE comment_id=c.comment_id;


this query returned error like




Query : SELECT COUNT(comment_id) FROM tbl_comment c WHERE superior_id LIKE '%' + account_id + '%' AND 'account_id' NOT IN (SELECT super...
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ account_id + '%' AND 'account_id' NOT IN (SELECT superior_id FROM tbl_comment_' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000







mysql sql







share|improve this question









New contributor




athulya is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct. 











SELECT COUNT(comment_id) 

FROM tbl_comment c  

WHERE superior_id LIKE '%' + account_id + '%' 

AND 'account_id' NOT IN (

    SELECT superior_id 

    FROM tbl_comment_reply 

    WHERE comment_id=c.comment_id;


this query returned error like




Query : SELECT COUNT(comment_id) FROM tbl_comment c WHERE superior_id LIKE '%' + account_id + '%' AND 'account_id' NOT IN (SELECT super...
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ account_id + '%' AND 'account_id' NOT IN (SELECT superior_id FROM tbl_comment_' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000







mysql sql




mysql sql






share|improve this question









New contributor




athulya is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




athulya is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited 18 hours ago









Barbaros Özhan

10.6k71430




10.6k71430






New contributor




athulya is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 18 hours ago









athulya

1




1




New contributor




athulya is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





athulya is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






athulya is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




put on hold as off-topic by Barbaros Özhan, Joakim Danielson, Madhur Bhaiya, mickmackusa, AdrianHHH 18 hours ago


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "This question was caused by a problem that can no longer be reproduced or a simple typographical error. While similar questions may be on-topic here, this one was resolved in a manner unlikely to help future readers. This can often be avoided by identifying and closely inspecting the shortest program necessary to reproduce the problem before posting." – Barbaros Özhan, Joakim Danielson, Madhur Bhaiya, mickmackusa, AdrianHHH

If this question can be reworded to fit the rules in the help center, please edit the question.




put on hold as off-topic by Barbaros Özhan, Joakim Danielson, Madhur Bhaiya, mickmackusa, AdrianHHH 18 hours ago


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "This question was caused by a problem that can no longer be reproduced or a simple typographical error. While similar questions may be on-topic here, this one was resolved in a manner unlikely to help future readers. This can often be avoided by identifying and closely inspecting the shortest program necessary to reproduce the problem before posting." – Barbaros Özhan, Joakim Danielson, Madhur Bhaiya, mickmackusa, AdrianHHH

If this question can be reworded to fit the rules in the help center, please edit the question.








  • 1




    There's no joins in that... why do you mention one in your title? (PS: Count your parenthesis).
    – Shawn
    18 hours ago






  • 2




    You have a bracket missing from your SQL - was that accidental copy paste error or is it missing from the original?
    – slugster
    18 hours ago










  • Did you really intend to check the literal string 'account_id' for being in a list of values, or did you intend to check the contents of the account_id column?
    – Caius Jard
    17 hours ago










  • account_id used at like operator is variable?
    – DPS
    17 hours ago






  • 1




    MySQL doesn't have a concat operater (|| in Standard SQL, + in SQL Server), it's using concat instead: 'concat(%', account_id, '%'). And AND 'account_id' should be AND account_id without quotes
    – dnoeth
    16 hours ago
















  • 1




    There's no joins in that... why do you mention one in your title? (PS: Count your parenthesis).
    – Shawn
    18 hours ago






  • 2




    You have a bracket missing from your SQL - was that accidental copy paste error or is it missing from the original?
    – slugster
    18 hours ago










  • Did you really intend to check the literal string 'account_id' for being in a list of values, or did you intend to check the contents of the account_id column?
    – Caius Jard
    17 hours ago










  • account_id used at like operator is variable?
    – DPS
    17 hours ago






  • 1




    MySQL doesn't have a concat operater (|| in Standard SQL, + in SQL Server), it's using concat instead: 'concat(%', account_id, '%'). And AND 'account_id' should be AND account_id without quotes
    – dnoeth
    16 hours ago










1




1




There's no joins in that... why do you mention one in your title? (PS: Count your parenthesis).
– Shawn
18 hours ago




There's no joins in that... why do you mention one in your title? (PS: Count your parenthesis).
– Shawn
18 hours ago




2




2




You have a bracket missing from your SQL - was that accidental copy paste error or is it missing from the original?
– slugster
18 hours ago




You have a bracket missing from your SQL - was that accidental copy paste error or is it missing from the original?
– slugster
18 hours ago












Did you really intend to check the literal string 'account_id' for being in a list of values, or did you intend to check the contents of the account_id column?
– Caius Jard
17 hours ago




Did you really intend to check the literal string 'account_id' for being in a list of values, or did you intend to check the contents of the account_id column?
– Caius Jard
17 hours ago












account_id used at like operator is variable?
– DPS
17 hours ago




account_id used at like operator is variable?
– DPS
17 hours ago




1




1




MySQL doesn't have a concat operater (|| in Standard SQL, + in SQL Server), it's using concat instead: 'concat(%', account_id, '%'). And AND 'account_id' should be AND account_id without quotes
– dnoeth
16 hours ago






MySQL doesn't have a concat operater (|| in Standard SQL, + in SQL Server), it's using concat instead: 'concat(%', account_id, '%'). And AND 'account_id' should be AND account_id without quotes
– dnoeth
16 hours ago



















active

oldest

votes






















active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes

-

Popular posts from this blog

Xamarin.iOS Cant Deploy on Iphone

Image
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } -1 I have a windows laptop and a mac mini my problem is that It wont deploy on iphone if I use Visual Studio Xamarin on windows to install my app, but it works fine with Visual Studio For Mac. Here's what I get after build succeded on Visual Studio Xamarin on windows : 1>------ Build started: Project: FinalCustomerApp.iOS, Configuration: Debug iPhone ------ 1> Connecting to Mac server 192.168.8.100... 1> FinalCustomerApp.iOS -> C:UsersJeremy PaulDesktopFinalCustomerAppFinalCustomerAppFinalCustomerApp.iOSbiniPhoneDebugFinalCustomerApp.iOS.exe 1> Detected signing identity: 1> Code Signing Key: &quo
Read more

Glorious Revolution

Image
"The Bloodless Revolution" redirects here. For a history of the vegetarian movement, see The Bloodless Revolution (book). This article is about the English revolution of 1688. For the revolution of 1868 in Spain, see Glorious Revolution (Spain). For other uses, see Glorious Revolution (disambiguation). Glorious Revolution The Prince of Orange lands at Torbay Date 1688–1689 Location British Isles Also known as Revolution of 1688 War of the English Succession Bloodless Revolution Participants English, Welsh and Scottish society, Dutch forces Outcome Replacement of James II by William III and Mary II Jacobite rising of 1689 Williamite War in Ireland War with France; England and Scotland join Grand Alliance Drafting of the Bill of Rights 1689 Part of a series on the History of England Timeline Prehistoric Britain Roman Britain Sub-Roman Britain Medieval period Economy in the Middle Ages Anglo-Saxon period
Read more

Dulmage-Mendelsohn matrix decomposition in Python

Image
0 Matlab has a function called dmperm that computes the so-called Dulmage–Mendelsohn decomposition of a n x n matrix. From wikipedia, the Dulmage–Mendelsohn is a partition of the vertices of a bipartite graph into subsets, with the property that two adjacent vertices belong to the same subset if and only if they are paired with each other in a perfect matching of the graph. Looking both on scipy and numpy, I could not find this function, nor some similar version. Is it possible to implement it using basic linear algebra operations? Any idea if this is implemented in some Python package? python matlab linear-algebra graph-theory matrix-decomposition share | improve this question
Read more