Re: Regular expression question

How about using the lower() function? Leon Vismer wrote:

Hi I would like to convert from one naming convention within a sql statement to another. I have the following, <code> $str = "insert into userComment (userID, userName, userSurname) values (0, 'Leon', 'Vismer')"; $match = array( "/([a-z]+)(ID)/", "/([a-z]+)([A-Z])/" ); $replace = array( "\$1_id", "\$1_\$2" ); $nstr = preg_replace($match, $replace, $str); echo $nstr ."\n"; </code> the above gets me to insert into user_Comment (user_id, user_Name, user_Surname) values (0, 'Leon', 'Vismer') however I want to get to insert into user_comment (user_id, user_name, user_surname) values (0, 'Leon', 'Vismer') Some help from the regex experts ;-) Many thanks -- Leon