キャラ名検索の実行結果

SQLの説明

キャラ名検索

検索結果

実行したSQL

      SELECT
   gamelist.gamename  as ゲーム,                   
   createrlist.name   as 声優名,                   
   shokushu.shubetu_detail_name as キャラ名        
from                                               
   gamelist,                                       
   shokushu,                                       
   createrlist                                     
where                                              
   shokushu.game = gamelist.id and                 
   shokushu.creater    = createrlist.id and        
   shokushu.shubetu_detail_name LIKE '%charname%'