mysql substring(列名，起始位置，长度)
select * from user where substring(Host,1,2)='lo' and substring(Host,6,1)='x';
--->取前 取后 匹配的索出来..
informix substr 语法同上
