Urgent Regular expression to allow only alpha characters and % wildcard

[MJoe]

Hi,

I need a regular expression to check that only alpha characters
are entered in a name field search and the wildcard character % Eg: %Joh%

[travishein]

isn't this just

[A-Za-z\%]+

see also: Tutorial

[masijade]

P.S. Use PreparedStatement. I can almost guarantee that you think you need this because you are cobbling together sql statements from string values. Do not do that. Use PreparedStatement.

Edit: Besides "_" is also a valid wildcard in sql, and numbers are, of course, also valid. And the "word" characters are 0-9,a-z,A-Z, and "_", so simply "\\w".