Custom query to get post names beginning with a digit

The solution given by @RolandoMySQLDBA will give you all posts because you have a * and not a +. The * means to return zero or more matches, which is not what you want. In this case, you actually don’t need either, but just to match the first character. Try this:

$sql .= $wpdb->prepare( " AND $wpdb->posts.post_name REGEXP '^[0-9]'");

Related Posts:

  1. How to return number of found rows from SELECT query
  2. Can i use php sql functions instead of $wpdb?
  3. $wpdb->delete column values IN ARRAY()?
  4. WordPress get pagination on wpdb get_results
  5. Ajax $wpdb not returning table data
  6. Converting MYSQL to WordPress $WPDB
  7. Why is variable not working on custom sql query using wpdb?
  8. Show MySQL errors that occur when I excute $wpdb->insert()
  9. Can’t get wp_insert_post to work
  10. WSoD being caused by this piece of code
  11. I want to select the from values from database in WordPress? [closed]
  12. Update results, Before deleting the related category [closed]
  13. wp query foreach deleting record returning only first or last item
  14. Database query works fine outside WordPress
  15. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  16. $wpdb->insert() does not Insert record in a table
  17. Help with a $wpdb MySQL Query
  18. Custom array from a query only write the last row of the query
  19. $wpdb returns duplicate posts
  20. Mixing variables into an array when inserting values
  21. Use $wpdb or other PHP script method to find/replace in WP database
  22. How can I add a new row in a separate database when someone registers via WordPress?
  23. Basic wpdb update question
  24. I can’t update my data through $wpdb
  25. Output: “Array”
  26. How to use mysql LIKE with wpdb?
  27. How do I prepare strings for insertions as values into a MySQL table?
  28. How to use AJAX in WordPress in MYSQL query?
  29. form $_post action value gets truncated after it passes through two forms
  30. Why won’t this wpdb get_results query return results?
  31. WPDB secure custom form
  32. Add row to custom database Table and delete all rows older than 1 day
  33. select a single val though a table in wordpress
  34. populate select options from extra mysql table data
  35. Query the links Database
  36. MySQL Query Returns Array () In Shortcode
  37. Passing in MySQL prepare statement parameter separately throwing error
  38. Convert a column of a table containing an Array as response in HTML
  39. Database SQL query error
  40. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  41. Conditional formatting on data fetched from MYSQL
  42. What is the correct way to search 3 custom fields only in WordPress?
  43. Using wpdb to connect to a different database is not working
  44. Rewrite SQL query as a prepared statement and use in foreach loop
  45. Advanced WordPress SQL Query
  46. MySQL query in WordPress with AJAX
  47. Passed variable gets undefined variable error on insert on next page
  48. MySQL queries in WordPress
  49. Using the same shortcode to show any table from the database
  50. MySQL database migration to WordPress
  51. Error resetting database index using ALTER TABLE in $wpdb->query
  52. Putting form result in my database
  53. How can I update a value of a field depending on outside source?
  54. How to validate WordPress generated password in DB using PHP?
  55. wpdb::prepare was called incorrectly
  56. Jquery ajax to custom php file: returning blank data
  57. Add value to usermeta without removing previous values?
  58. How can I call a row of user specific data from a custom table added to the WP Database
  59. How to merge local and live databases?
  60. Performance issues with large website [closed]
  61. Create a quick start wordpress installation [closed]
  62. theme options echoing multiple times
  63. WordPress 3 – how are passwords stored and how do I compare to them?
  64. how to echo all tables that start with a prefix
  65. How to select WooCommerce products by post_meta and order them
  66. Any possible way to make $wpdb->get_results() return anything else than array?
  67. Remove one value in dismissed_wp_pointers?
  68. Accessing data from a non-WP database/table within a page content
  69. How can I save unique user data on my site? [closed]
  70. Ordering users by custom user meta
  71. Force Users To Relogin
  72. how to get serialized post meta
  73. A $_POST should occur when submit form but is not?
  74. Pull MySQL data from multiple tables and merge into 1 PHP array
  75. Using CFDB7 vs Custom MySQL Database [closed]
  76. Adding data to custom wordpress database table
  77. Undefined variable: row?
  78. Removal of all posts content in bulk, keeping the posts itself
  79. Add posts to custom table in database instead of wp_posts
  80. How to store checkbox data for individual users?
  81. Usermeta data unserialize, extract and display in table in WordPress
  82. I can’t separate the array by commas
  83. Displaying SQL query result from user input via wpdb
  84. How can i limit the number of posts to the most recent 6 in my query?
  85. How do I create a WP endpoint that retrieves all custom post types that have a tag?
  86. How to grab data from input and store it into custom table in database?
  87. (Who to follow) Twitter widget
  88. Update user_email via php – WP 4.7
  89. How can I display a query in a page?
  90. Unable to pass variable to database
  91. How to properly send many mysql queries via php and what happens with ajax requests after they are sent?
  92. How to set up an auto delete post?
  93. WordPress upload images not displaying
  94. MySQL update text field with ‘
  95. How do you get a reference to $wpdb in a PHP script
  96. Query Concatenation
  97. Display total count of products in orders of a specific order status
  98. WordPress Query -> Ajax Query
  99. SQL – How to echo out inside of where statement
  100. WordPress Query with meta_key and order by another meta_key

Leave a Comment