return mysql string using regex

Question

Here is my code:

$sql = "SELECT `description` FROM `auctions` WHERE `description` REGEXP '[0-9]{10}'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
  echo $row["description"];
}

This returns the whole field description, I need to just get the part that matches the REGEXP, how do I do this using php?

You have to do that in plain PHP because, if you move the regex part into the select, it will only return 0 or 1. See the documentation. (and you can see an example here) — j0k
– j0k, Commented Jan 22, 2013 at 8:35
Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — NullPoiиteя
– NullPoiиteя, Commented Jan 22, 2013 at 8:40

Barmar · Accepted Answer · 2013-01-22 21:32:07Z

1

$sql = "SELECT `description` FROM `auctions` WHERE `description` REGEXP '[0-9]{10}'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
    preg_match('/\d{10}/', $row["description"], $match);
    echo $match[0];
}

edited Jan 22, 2013 at 21:32

answered Jan 22, 2013 at 8:31

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MC Emperor · Accepted Answer · 2013-01-22 08:48:52Z

0

Try this:

$results = array();
$sql = "SELECT `description` FROM `auctions` WHERE `description` REGEXP '[0-9]{10}'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
    // Checks for a match in the description and capture the match to $match
    preg_match("/[0-9]{10}/", $row['description'], $match);

    // Save the complete match (the ten digits) to the results array.
    $results[] = $match[0];
    // Or just echo them
    echo $match[0];
}

By the way, you also should take a look at prepared statements, inter alia to prevent SQL injections.

edited Jan 22, 2013 at 8:48

answered Jan 22, 2013 at 8:35

MC Emperor

23.3k16 gold badges90 silver badges139 bronze badges

Collectives™ on Stack Overflow

return mysql string using regex

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related