“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

Bressuire

Image
Subprefecture and commune in Nouvelle-Aquitaine, France Bressuire Subprefecture and commune Chateau de Bressuire and the Eglise Notre-Dame Coat of arms Location of Bressuire Bressuire Show map of France Bressuire Show map of Nouvelle-Aquitaine Coordinates: 46°50′27″N 0°29′14″W  /  46.8408°N 0.4872°W  / 46.8408; -0.4872 Coordinates: 46°50′27″N 0°29′14″W  /  46.8408°N 0.4872°W  / 46.8408; -0.4872 Country France Region Nouvelle-Aquitaine Department Deux-Sèvres Arrondissement Bressuire Canton Bressuire Government  • Mayor .mw-parser-output .nobold{font-weight:normal} (2014–20) Jean Michel Bernier Area 1 180.59 km 2 (69.73 sq mi) Population (2014) 2 19,300  • Density 110/km 2 (280/sq mi) Time zone UTC+01:00 (CET)  • Summer (DST) UTC+02:00 (CEST) INSEE/Postal code 79049 /79300 Elevation 98–236 m (322–774 ft) (avg. 173 m or 568 ft) 1 French Land Register data, which exclude...
Read more

Vorschmack

Image
Vorschmack Ukrainian Jewish-style vorschmack served on rye bread Course Hors d'oeuvre Region or state Eastern Europe Associated national cuisine Ashkenazi Jewish, Finnish, German, Ukrainian, Polish, Russian Main ingredients Ground meat and/or fish Cookbook: Vorschmack   Media: Vorschmack Vorschmack or forshmak (Yiddish: פֿאָרשמאַק ‎, from archaic German Vorschmack , "foretaste" [1] or "appetizer" [2] ) is an originally East European dish made of salty minced fish or meat. Different variants of this dish are especially common in Ashkenazi Jewish and Finnish cuisine. Some varieties are also known in Russian and Polish cuisine. Contents 1 In Jewish cuisine 2 In Russian cuisine 3 In Polish cuisine 4 In Finnish cuisine 5 See also 6 References In Jewish cuisine According to Gil Marks, the German name points to the possible Germanic origin of this dish. [1] William Pokhlyobkin descr...
Read more

Quarantine

Image
For other uses, see Quarantine (disambiguation). Signal flag "Lima" called the "Yellow Jack" which when flown in harbor means ship is under quarantine. A simple yellow flag (also called the "Yellow Jack") had historically been used to signal quarantine (it stands for Q among signal flags), but now indicates the opposite, as a signal of a ship free of disease that requests boarding and inspection. A quarantine is used to separate and restrict the movement of people; it is 'a restraint upon the activities or communication of persons or the transport of goods designed to prevent the spread of disease or pests', for a certain period of time. [1] This is often used in connection to disease and illness, such as those who may possibly have been exposed to a communicable disease. [2] The term is often erroneously used to mean medical isolation, which is "to separate ill persons who have a communicable disease from those who are healthy...
Read more