0

I have an issue with my SQL code. I am trying to count the rows in one table and then post the result along with the remaining variables in a different table. The LIKE statement seems to not work. Everywhere I look I see that I am supposed to do it like the picture without brackets, but sql refuses to let me run it and gives me some syntax error I don't understand. Then I tried it with brackets and it just completely ignore what is inside the brackers it seems like. It just posts 0 as the answer even though it's supposed to be 9. If someone could be of help that would be nice. Code without brackets Code with brackets

fadi tantawi
  • 1
  • 2
  • 1
    Do not post code as image, but edit your question and add it as text. Try and use `tweet_text LIKE CONCAT('%', @weg, '%'); `. The same for `datum` . Check for more info: https://stackoverflow.com/questions/8537516/how-to-use-an-user-variables-in-mysql-like-clause – Ergest Basha Oct 07 '21 at 20:27
  • Thank you this worked! I will copy paste my code from now on! – fadi tantawi Oct 08 '21 at 00:05

0 Answers0