I have a MySQL table column with a lot of rows.
Below is a sample of the data format:
TEST-DATA (ID:123)
How can I remove the part (ID:123), using PHP regular expressions?
Please note that (ID:123) contains different numbers for each row in the table column.
TESTDATA2(ID:1)
DATAAGAIN(ID:78)
MOREDATA(ID:45)
...
You can use preg_replace().
preg_replace — Perform a regular expression search and replace
Example:
echo preg_replace("/\([^\)]+\)/", "", $value);
Expression breakdown:
/ - Opening delimiter
\( - Match an opening parenthesis
[^\)]+ - Match one or more characters that are not a closing parenthesis
\) - Match a closing parenthesis
/ - Closing delimiter
Replace $value with the variable for your column value.
Try this:
$string = preg_replace( '/\(ID:[0-9]+\)/', '', $string );
