Checking certain item in MySQL?

[donkeyg]

how to check certain item like "Thanatos Card" at mysql database.. i wanna see who got that card..

[Rayhan]

Just search the name ID in your database.

[Cydh]

I'm forget to make this simplier.. xD

SELECT
(SELECT COUNT(*) FROM `cart_inventory` WHERE `nameid` = '1201')+
(SELECT COUNT(*) FROM `storage` WHERE `nameid` = '1201')+
(SELECT COUNT(*) FROM `guild_storage` WHERE `nameid` = '1201')+
(SELECT COUNT(*) FROM `inventory` WHERE `nameid` = '1201') AS `Result` 

change 1201 to thanatos card id