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

Code:

"select count("id_employee) from mytable"