$wpdb->prepare with LIKE returning blank array instead of rows

Your SQL doesn’t look right. It should be more like

$prep = $wpdb->prepare( "SELECT * FROM {$table_name} WHERE name LIKE '%s'", $city );

Related Posts:

  1. Use wpdb->prepare for `order by` column name
  2. prepare() not working
  3. wpdb prepare sql problem
  4. What is a stored procedure?
  5. Unknown column in ‘field list’ error on MySQL Update query
  6. Conversion failed when converting date and/or time from character string while inserting datetime
  7. error, string or binary data would be truncated when trying to insert
  8. ORA-00907: missing right parenthesis
  9. Rename column SQL Server 2008
  10. Why do we need “Relationships” between tables at all?
  11. Using group by on multiple columns
  12. How to declare a variable in MySQL?
  13. ORA-01843 not a valid month- Comparing Dates
  14. How do I escape a single quote in SQL Server?
  15. How Stuff and ‘For Xml Path’ work in SQL Server?
  16. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  17. Oracle SELECT TOP 10 records
  18. must appear in the GROUP BY clause or be used in an aggregate function
  19. The multi-part identifier could not be bound
  20. MySQL syntax for Join Update
  21. SQLite – UPSERT *not* INSERT or REPLACE
  22. how to drop partition without dropping data in MySQL?
  23. What is it exactly a BLOB in a DBMS context
  24. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  25. Insert text with single quotes in PostgreSQL
  26. SQL Server IF NOT EXISTS Usage?
  27. How to insert date values into table
  28. Arithmetic overflow error converting numeric to data type numeric
  29. I want to use CASE statement to update some records in sql server 2005
  30. SELECT DISTINCT on one column
  31. how to remove time from datetime
  32. Query to convert from datetime to date mysql
  33. How to query MongoDB with “like”
  34. Equivalent of Oracle’s RowID in SQL Server
  35. Subtract one day from datetime
  36. MySQL equivalent of DECODE function in Oracle
  37. what is the difference between triggers, assertions and checks (in database)
  38. Replacing NULL with 0 in a SQL server query
  39. How to delete from multiple tables in MySQL?
  40. How to copy a row and insert in same table with a autoincrement field in MySQL?
  41. Error converting data type varchar
  42. I want to use CASE statement to update some records in sql server 2005
  43. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  44. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  45. ROW_NUMBER() in MySQ
  46. Foreign key references invalid table
  47. What are database constraints?
  48. Postgresql column reference “id” is ambiguous
  49. Inner Joining three tables
  50. How do I view the Explain Plan in Oracle Sql developer?
  51. ORA-01779: cannot modify a column which maps to a non key-preserved table
  52. SUM OVER PARTITION BY
  53. MySQL LIKE IN()?
  54. Filter data based on date in sql
  55. Varchar invalid for Sum operator
  56. SQL: How to properly check if a record exists
  57. How do you properly prepare a %LIKE% SQL statement?
  58. SQL query to extract only the “current” wp_posts?
  59. Sorting search results by taxonomy terms
  60. SQL select of users by metadata
  61. How to properly sanitize strings without $wpdb->prepare?
  62. Retrieving custom fields with $wpdb->get_results
  63. How to remove in the wordpress database all posts revisions except the last three?
  64. Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
  65. show badge with count for pending items in custom post type
  66. How to correctly pass values to wpdb->prepare()?
  67. WP Sql query multiple where clause
  68. posts_where Fails with More than One Custom Field in Query
  69. Syntax for $wpdb->prepare when searching in two columns
  70. Can’t get result from sql using ajax result
  71. WordPress database error: You have an error in your SQL syntax
  72. Optimizing WordPress Queries – Removing Group By ID
  73. Restose content from revisions – sql query
  74. $wpdb->insert() does not Insert record in a table
  75. WordPress SQL Issue not returning correct reselts
  76. Inner Join user tables to select users with roles
  77. WPDB SQL query with prepare() returning variable, not db value
  78. Posts modified in the last 48 hours
  79. How to left join meta in queries [closed]
  80. Sql formatting for post data within function
  81. CREATE TABLE with dbDelta does not create table
  82. $wpdb->prepare affecting the query?
  83. prepare function sql safe method
  84. post id not displaying
  85. Creating multiple tables with Plugin
  86. how to list all post that are in the custom taxonomy using $wpdb
  87. sort title descending with title with number
  88. Correct and secure way to access a custom SQL database in a custom PHP template file
  89. Creating an Angular factory from custom database table
  90. $wpdb query for price in custom field value
  91. Insert multiple checkbox values
  92. Run an update query in a function
  93. Custom database query to validate data
  94. Creates only one table and not the other
  95. looking for a way to allow users to backup the plugin db data(save as)
  96. Querying multiple meta_keys in WordPress SQL query
  97. Custom WordPress SQL Query 4 posts per custom taxonomy
  98. How to get EVENT based on startday, using BETWEEN
  99. wpdb LIKE request shows all database data
  100. wpdb prepare without placeholder