help with regular expression

[jasongr]

Hi people

I need help with a simple regular expression.
I am given a PHP buffer. I need to know if the following phrase appears in it:
INSERT INTO <table name>

where <table name> is a name of a sql table. It can contain characters (upper and lower) and underscores.
Here are possible values:
INSERT INTO mytable
INSERT INTO another_table

right after the name of the table needs to be a whitespace or newline.

can anyone help me with that?

regards
Jason

[kleineme]

preg_match_all('~INSERT\s+INTO\s+[a-z_]+\s~i', $buffer, $m); 

[computerbarry]

preg_match_all('~INSERT\s+INTO\s+[a-z_]+\s~i', $buffer, $m); 

You did say upper aswell?

preg_match_all('~INSERT\s+INTO\s+[a-zA-Z_]+\s~i', $buffer, $m); 

Correct me if am wrong on that?

[bokehman]

Correct me if am wrong on that?

It's not wrong, it's just belt and braces. Check out the "i" modifier at the end of the expression.

[onequickmemory]

Try the character class [[:space:]] in your regex. It is used for any white space.

[kleineme]

Try the character class [[:space:]] in your regex. It is used for any white space.

What is the benfit of using [:space:] instead of \s, which is also used for any white space? By the way, does anyone know why there is no explanation of these predefined character classes in the PHP-manual, except for an user note, although they use it in one of their examples?

[bokehman]

What is the benfit of using [:space:] instead of \s

[:space:] is a POSIX character class, not PCRE. Don't try to use it with the preg functions.

[voodoomagic]

What is the benfit of using [:space:] instead of \s, which is also used for any white space? By the way, does anyone know why there is no explanation of these predefined character classes in the PHP-manual, except for an user note, although they use it in one of their examples?

who knows.. but check this out: http://www.htmlite.com/php034.php

[stereofrog]

By the way, does anyone know why there is no explanation of these predefined character classes in the PHP-manual

Because they forgot it?

Anyways, here's the complete list (from http://lxr.php.net/source/php-src/ex...ompile.c#132):

"alpha", "lower", "upper",
"alnum", "ascii", "blank", "cntrl", "digit", "graph",
"print", "punct", "space", "word", "xdigit"