How to return row count of mysql sub query?

Simply like that : SELECT games. Id, games. GameTitle FROM games WHERE ( SELECT COUNT(filename) FROM banners WHERE banners.

Keyvalue = games. Id AND banners. Filename LIKE '%front%' ) > 1.

1 You beat me to it. COUNT(*) will also work. – Mike May 26 at 20:14 thank you very much... that worked a treat..... I was sooo close as well!

– Alex May 26 at 20:14 @Mike since the selection was on filename in the original query, I kept that. @Alex glad I could help := – krtek May 26 at 20:16.

SELECT games. Id, games. GameTitle FROM games WHERE EXISTS (SELECT COUNT(filename) FROM banners WHERE banners.

Keyvalue = games. Id AND banners. Filename LIKE '%front%' HAVING COUNT(filename)>1).

1 maybe faster than my own answer, a little test should be made... – krtek May 26 at 20:15.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.