开头字母是a--g、h--n、o--t、u--z的JPQL语句

查询Actor的stageName开头字母是a--g、h--n、o--t、u--z的JPQL语句。
String strQuery = "select a from Actor a";
if(word.equals("AG")){
         strWhere = " where a.stageName like 'a%' or a.stageName like 'b%' or a.stageName like 'c%' or a.stageName like 'd%' or a.stageName like 'e%' or a.stageName like 'f%' or a.stageName like 'g%' ";
}else if(word.equals("HN")){
         strWhere = " where a.stageName like 'h%' or a.stageName like 'i%' or a.stageName like 'j%' or a.stageName like 'k%' or a.stageName like 'l%' or a.stageName like 'm%' or a.stageName like 'n%' ";
}else if(word.equals("OT")){
         strWhere = " where a.stageName like 'o%' or a.stageName like 'p%' or a.stageName like 'q%' or a.stageName like 'r%' or a.stageName like 's%' or a.stageName like 't%' ";
}else if(word.equals("UZ")){
         strWhere = " where a.stageName like 'u%' or a.stageName like 'v%' or a.stageName like 'w%' or a.stageName like 'x%' or a.stageName like 'y%' or a.stageName like 'z%' ";
}

 

1.想用in的用法来做a--z的26个字母。
错误的写法(1)：
   select a.* from actor a where a.stage_name like ('Aa%','Bb%','Cc%','Dd%','e%','f%');
错误的写法(2)：
   select a.* from actor a where a.stage_name in ('Aa%','Bb%','Cc%','Dd%','e%','f%');
2.如果想用In的话，这样来写:
    select a.* from actor a where a.stage_name in ('Aa','Bb','Cc','Dd','e','f');
但是这样写就达不到模糊查找。
3.所以还必须按照一个字母一个字母的like来写,就是上面的那个方法了。

 

in的SQL写法：
   select  distinct s.* from scene s, scene_video sv where s.id=sv.scene_id and  (sv.video_url like '%.Med.%' or playlist_file like '%.med.%' )  and s.id in (4,5,6,7,8,9) order by s.created desc