String replace method

[venkata.tarigopula]

Hi all,

I have a problem with string replacement. Details follows...

String : select count(*) from my_table

I have to replace count(*) with count(1).But The String's replaceAll() asking for regular expressions..can u just tell me what regular expression suits my needs?

I don't want to use replace() method...Can u tell me...

Thanks in advance..

[paty]

Are you working with SQL?
you have to write string expressions
you can't write "2" or "1"
you have to write some column of your data base
like this

"select count("id_employee) from mytable"