Hi Rakesh, If you would like to get all the names starting with r, you can use
select * from emp where name like 'r%'; or select * from emp where name rlike '^r'; or select * from emp where name regexp '^r'; Thanks. Pengcheng On Thu, Aug 20, 2015 at 11:40 AM, rakesh sharma <[email protected]> wrote: > Hi All > > I am trying to get all the names starting with r. > My query looks like > select * from emp where name like 'r~%'; > > But it doesn't result anything; > > Any help > > thanks > rakesh >
