wpdb query not working

It’s probably because you must use % sign for “like” so it would be:

SELECT * FROM `wp_usermeta` 
WHERE meta_key= 'referrer' AND 
meta_value LIKE '%270%' AND 
meta_key= 'view_type' AND 
meta_value LIKE '%invoice%'

Related Posts:

  1. How to use $wpdb to delete in a custom table
  2. get_results on large datasets
  3. Is there a (better) way to access $wpdb results?
  4. Using $wpdb generates DB error
  5. How do you use prepare when asking for a list of id’s
  6. how to execute different sql query in non-sanitized $wpdb->get_results function
  7. WPDB update row with != in where clause
  8. How to update records using $wpdb?
  9. Need help writing a $wpdb query
  10. show badge with count for pending items in custom post type
  11. WP Sql query multiple where clause
  12. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  13. Modify the structure of data returned by $wpdb
  14. Syntax for $wpdb->prepare when searching in two columns
  15. Confused by $wpdb->prepare
  16. How to display user_nicename and usermeta values by custom query in WordPress?
  17. Optimizing WordPress Queries – Removing Group By ID
  18. How can I combine one field using wpdb and group by?
  19. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  20. how to use $wpdb->prepare to update a custom table
  21. WPDB Placeholders and second argument for prepared statements
  22. Increment integer field in database when WHERE needs to be dynamic [closed]
  23. Custom SQL query ORDER BY term_order
  24. Custom $wpdb returns unexpected time based results
  25. How to left join meta in queries [closed]
  26. wpdb->get_row is selecting the variable as a column name
  27. CREATE TABLE with dbDelta does not create table
  28. $wpdb query outputs php code instead of executing it
  29. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  30. WPDB SQL Ignore `post_status` Parameter
  31. how to list all post that are in the custom taxonomy using $wpdb
  32. WPDB SQL query SELECT from category
  33. How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
  34. Creating an Angular factory from custom database table
  35. wpdb->update update the entire table instead of one row
  36. How do I update post based on meta_key in another table?
  37. How to set up prepared query using IN statement
  38. Custom database query to validate data
  39. Alter the main search query to search posts by coauthor user name
  40. Creates only one table and not the other
  41. Protect custom form from SQL injection
  42. looking for a way to allow users to backup the plugin db data(save as)
  43. SQL Query to select post title & post ID from a particular category
  44. Get comments after specific date
  45. query using wpdb in wordpress gets me no result
  46. Get count of rows based if column exists in two different tables
  47. query_vars doesn’t return query string (trying to get data from $wpdb)
  48. How do you properly prepare a %LIKE% SQL statement?
  49. $wpdb->insert() and Values for Datetime Columns?
  50. Change post status based on meta value
  51. Speed optimization of $wpdb->get_results
  52. $wpdb is get_results escaped
  53. wpdb prepare: passing varible number of fields as second argument
  54. Wpdb query for comment meta for current post
  55. How to Modify this $wpdb query to accept an array of post statuses
  56. WPDB Update using Conditional Arrays
  57. How to correctly pass values to wpdb->prepare()?
  58. $wpdb->get_results returns empty but value exists
  59. Problem displaying inserted form
  60. Get published posts and pages?
  61. How to get a value-only flat array from $wpdb->get_results when selecting a single column, without foreach()?
  62. How to Instantiate wpdb Object in New File
  63. Would this WPDB setup result in potential race conditions?
  64. How to update a row in a table in WordPress
  65. External DB Connection [closed]
  66. Codex: Database Description: meaning of Cardinality
  67. $wpdb->insert() does not Insert record in a table
  68. WordPress SQL Issue not returning correct reselts
  69. WordPress db prepare
  70. $wpdb->prepare with LIKE returning blank array instead of rows
  71. $wpdb update query in plugin only updating one column
  72. Custom Query – Based on user input
  73. how to get db values without using an loop with wpdb->get_results()
  74. How to run wp_insert_post() & wpdb on the background?
  75. Trying to get variable from WP table and toggle its value
  76. Set MySQL variables in WPDB
  77. get_results query with accent
  78. How to prepare an array of values with $wpdb
  79. Is querying wpdb directly and skipping actions provided by WP’s core “wp_update_post” a good idea?
  80. Getting values from wpdb
  81. Why is this $wpdb query looping 5 times?
  82. wpdb query not returning results containing single quotes
  83. duplicate entries in database while using save_post or wp_insert_post
  84. Unknown column ‘siteurl’ in ‘where clause’ WPDB outside
  85. Creating multiple tables with Plugin
  86. sort title descending with title with number
  87. Create a stored procedure on plugin activation
  88. Get last element from wpdb as a string
  89. $wpdb query for price in custom field value
  90. Update all fields of table with ON DUPLICATE KEY UPDATE command
  91. WordPress – wpdb query does not list same result as sql query
  92. What is the best practice to initialise $wpdb by loading wp-load.php?
  93. $wpdb->get_results in not an array
  94. How to make iteration on wpdb->update or query statement?
  95. Querying multiple meta_keys in WordPress SQL query
  96. Custom WordPress SQL Query 4 posts per custom taxonomy
  97. Jeditable Plugin working as it should – scope issue?
  98. How do I change the datetime format from ( ‘y-m-d’ ) to ( ‘d m y’ ) [closed]
  99. Table wont load into WPDB
  100. WPDB prepare – like % – placeholders?