$wpdb query for price in custom field value

You can try the following:

AND ($wpdb->postmeta.meta_key = 'cc_price' AND $wpdb->postmeta.meta_value LIKE '%$s_prc%')

(Use cc_price instead of $cc_price)

Related Posts:

  1. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  2. wpdb get posts by taxonomy SQL
  3. Multipart/formatted MySQL query problem
  4. What’s wrong with my $wpdb prepare?
  5. wpdb query problem to access previous 3 days posts
  6. I can’t figure out what’s wrong with this statement. $wpdb->query update
  7. Custom Query – Based on user input
  8. $wpdb->prepare affecting the query?
  9. prepare function sql safe method
  10. How do I query for posts by custom meta and those that have been stickied?
  11. Fastest and most efficient SQL query to check if UID exists
  12. Run an update query in a function
  13. Wpdb generates too many queries
  14. Differences between wpdb->get_results() and wpdb->query()
  15. How to make an activities stream mixing posts and comments?
  16. Custom $wpdb Query for Custom Post Type by Category
  17. Can’t pass table to $wpdb->prepare
  18. WordPress creating excessive joins on meta_query with search
  19. $wpdb->get_var not returning a result
  20. cron job to auto delete posts of a specific post type older than x days
  21. Are database queries created using WordPress filters protected from SQL injection?
  22. Get posts by category with pure SQL query
  23. Custom query to get terms from post ids
  24. Get the timout value of a saved transient?
  25. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  26. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  27. wpdb::prepare() isn’t working
  28. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  29. $wpdb doesn’t appear to work on page inside of a plugin
  30. Strange string in console from wpdb query
  31. Using $wpdb->update but confused on the WHERE in and SET
  32. How to correctly pass values to wpdb->prepare()?
  33. Make one query for adding entries to database
  34. Get stock by custom meta field on all Woocommerce variable products
  35. How to execute a SQL-query which contains multiple queries using $wpdb->query?
  36. Alter a specific query on WordPress
  37. How do I see the mysql query generated by get_posts( $args )?
  38. sql select query in wordpress ‘page’ [closed]
  39. wpdb->term_taxonomy count posts from both published and private posts?
  40. wpdb print all post meta
  41. Plugin will sort users by usermeta
  42. problem with sql query in wordpress plugin
  43. Attempt to improve WP search, can someone check my SQL query?
  44. How to write: $wpdb->update having WHERE NOT value pair in the array
  45. Use mysql_query instead of $wpdb query
  46. wpdb COALESCE won’t work
  47. Custom SQL Query passing array to WHERE p.id
  48. Get posts from category with custom query
  49. Custom Query returns array, but I can’t see it’s elements
  50. how to insert missing tags into the posts through mySQL?
  51. PHP -> SQL Query with Summing
  52. Valid SQL query return empty
  53. mysql query – how to escape apostrophe?
  54. WordPress SQL search, how to handle SQL Injection?
  55. exclude pingbacks from wordpress SQL query
  56. Why my query does not run with prepare
  57. WordPress SQL query to tag all posts containing a specific word on title
  58. How to return count of custom post type posts with a specific custom field value via $wpdb?
  59. Select column name dynamically mySQL Query
  60. WordPress Mysql query and Duplicate
  61. Help with Related Posts Function
  62. wpdb update multiple row?
  63. Formatting a date/time returned from a custom $wpdb query
  64. Improve performance of slow query
  65. Change pure SQL database query to WordPress post query?
  66. How do I get specific readable results from this query and array results
  67. Cannot get sql request from Query object?
  68. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  69. Customising the default wordpress search functionality
  70. Display data from phpMyAdmin with WordPress
  71. Any way to use FETCH_KEY_PAIR with $wpdb?
  72. Delete oldest wordpress post (SQL query)
  73. SQL to Query the db and return all posts and it’s metas
  74. SQL query to delete users with multiple meta keys and comments
  75. Nested select statements not working
  76. Speed up search query that searches in post meta?
  77. implementing my wp_query using $wpdb class
  78. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  79. How to make MySQL search queries with quotes
  80. Use $wpdb->get_results with filter based on array
  81. How i make a custom sql query for Woocommerce
  82. Display result from custom post meta query
  83. Wpdb empty result only if language is Russian
  84. How to fix this insert? Don’t work for me!
  85. Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
  86. How to display a specific category using a custom Query in WordPress?
  87. Update vs Insert logic but the last key is always inserted?
  88. There is way to improve this query? wordpress get post data and some meta data
  89. $wpdb: how to use a query as a base for another query?
  90. Custom Query for searching through custom fields
  91. Custom WordPress SQL Query 4 posts per custom taxonomy
  92. Mysql query and odd results
  93. learn to run wpdb class
  94. How to reference same column name but different table in custom db query
  95. Retrieving custom field array value through db query
  96. SQL Query : how copy all tags of post into their post content in wordpress by sql query
  97. Where can I find the SQL to get the most used information by wordpress database?
  98. Custom Query for wp_posts using wp_postmeta
  99. 3 queries to update WordPress
  100. update $wpdb one query