Re: got wrong data with using '%' as condition

2015-07-10 Thread yiran9937
Hi Kristian, Thank you very much for your help. I got it with your suggestion. I changed SQL to 'select * from tig_users where user_id like 'test_01=_%' {escape '='};' and got the results same as I want. From this case, I know that ij work with JDBC rule. It is very useful for my next step to

Re: got wrong data with using '%' as condition

2015-07-09 Thread Kristian Waagan
Hi Li, '_' is a wildcard character matching a single character. To search for the literal '_' you have to escape it. There may be several ways to do that, but one is described here: https://db.apache.org/derby/docs/10.11/ref/rrefjdbc28456.html Regards, -- Kristian tor. 9. jul. 2015, 18.56