If number have inside number string [closed]

by

Well, you could perform a regular expression search on those strings, however doing so in a database with a large data set may prove rather costly.

$subjects = ["1568940","545198650", "15580", "5551000", "015", "1805"];

foreach ($subjects as $subject) {
    if (preg_match("/(1)\d*(5)\d*(0)\d*/", $subject, $match) && count($match) == 4) {
        echo "$subject contains string 150\n";
    } else {
        echo "$subject does not contain string 150\n";
    }
}

This should give you the following output…

1568940 contains string 150

545198650 contains string 150

15580 contains string 150

5551000 does not contain string 150

015 does not contain string 150

1805 does not contain string 150

In MySQL…

SELECT fieldname FROM table WHERE fieldname REGEXP "(1)*(5)*(0)*";

It might help if you explained in more detail how you’re getting this data and why it is you need to identify if it contains these characters.

More Related Contents:

  1. PDO Fetch statement only retrieves first column
  2. PHP insert ‘ into SQL [duplicate]
  3. How to add Hyperlink on php/html table that displays information from mysql database [closed]
  4. PHP + MySQL transactions examples
  5. How to display errors for my MySQLi query? [duplicate]
  6. How to retrieve images from MySQL database and display in an html tag
  7. Automated or regular backup of mysql data
  8. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client [duplicate]
  9. Best way to avoid duplicate entry into mysql database
  10. Fatal error: Call to undefined function session_register()
  11. PHP: Warning: sort() expects parameter 1 to be array, resource given
  12. PHP date() format when inserting into datetime in MySQL
  13. convert php date to mysql format
  14. Special characters in PHP / MySQL
  15. Fetching single row, single column with PDO
  16. MySQL db question marks instead of hebrew characters..?
  17. IP address storing in MySQL database using PHP [duplicate]
  18. “No such file or directory” or “No such host is known” when running migrations
  19. How to convert IPv6 from binary for storage in MySQL
  20. Password_Hash not working on my PHP login
  21. Select last 20 order by ascending – PHP/MySQL
  22. Formatting an SQL timestamp with PHP
  23. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  24. How does {} affect a MySQL Query in PHP? [duplicate]
  25. When should I close a database connection in PHP?
  26. Backup a mysql database and download as a file
  27. Is a BLOB converted using the current/default charset in MySQL?
  28. php connection pooling mysql [duplicate]
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment