Nested select statements not working

You need to identify the tables for each of the columns that have the same name. You should also be using an IN statement and not = for the department.

I can’t test this since I don’t have your DB but you can try this:

$sql = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . 
"dir_personnel as personnel where lname like '$search%' or fname like '$search%' or 
extension like '$search%' or personnel.department IN (SELECT id FROM " . $wpdb->prefix . 
"dir_departments as departments where departments.department like '$search%') order by lname");

Related Posts:

  1. How to display SQL query that ran in query?
  2. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  3. wpdb get posts by taxonomy SQL
  4. Multipart/formatted MySQL query problem
  5. WordPress creating excessive joins on meta_query with search
  6. cron job to auto delete posts of a specific post type older than x days
  7. Are database queries created using WordPress filters protected from SQL injection?
  8. Get posts by category with pure SQL query
  9. Custom query to get terms from post ids
  10. Get the timout value of a saved transient?
  11. Select query for a login
  12. What’s wrong with my $wpdb prepare?
  13. How do I see the mysql query generated by get_posts( $args )?
  14. sql select query in wordpress ‘page’ [closed]
  15. Select Query demand excesive resources [closed]
  16. problem with sql query in wordpress plugin
  17. Attempt to improve WP search, can someone check my SQL query?
  18. wpdb query problem to access previous 3 days posts
  19. I can’t figure out what’s wrong with this statement. $wpdb->query update
  20. Custom Query – Based on user input
  21. how to insert missing tags into the posts through mySQL?
  22. $wpdb->prepare affecting the query?
  23. WordPress SQL search, how to handle SQL Injection?
  24. exclude pingbacks from wordpress SQL query
  25. prepare function sql safe method
  26. WordPress SQL query to tag all posts containing a specific word on title
  27. Select column name dynamically mySQL Query
  28. How do I query for posts by custom meta and those that have been stickied?
  29. Change pure SQL database query to WordPress post query?
  30. Cannot get sql request from Query object?
  31. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  32. Display data from phpMyAdmin with WordPress
  33. SQL to Query the db and return all posts and it’s metas
  34. SQL query to delete users with multiple meta keys and comments
  35. Speed up search query that searches in post meta?
  36. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  37. Fastest and most efficient SQL query to check if UID exists
  38. How to make MySQL search queries with quotes
  39. How i make a custom sql query for Woocommerce
  40. $wpdb query for price in custom field value
  41. Run an update query in a function
  42. How to display a specific category using a custom Query in WordPress?
  43. Slow query when joining wp_posts with a lookup-table?
  44. Wpdb generates too many queries
  45. learn to run wpdb class
  46. SQL Query : how copy all tags of post into their post content in wordpress by sql query
  47. Where can I find the SQL to get the most used information by wordpress database?
  48. Custom Query for wp_posts using wp_postmeta
  49. 3 queries to update WordPress
  50. SQL conditional SELECT
  51. MySQL error: Unknown column in ‘where clause’
  52. Get Terms by IDs with IDs order
  53. Slow wp_enqueue_media()
  54. How to tell if $query_var isset?
  55. Sorting Grids with Essential Grid and Events Manger
  56. The use of including upgrade.php when building custom queries
  57. Does meta_query work within get_posts array?
  58. How to show more than 5 posts?
  59. WordPress Find Duplicate Post By Content
  60. WP Query Sort by meta value (date)
  61. how to query multiple categories in wordpress?
  62. Disable the MySQL query in the main query
  63. Update slug (URL) of pending posts via phpMyAdmin
  64. How can I get the query that would be run for the archive page?
  65. Query metas (and not : query posts by metas)
  66. where should I reset query after using get_results?
  67. Exclude featured image and custom field from this get_attachment query
  68. wpdb print all post meta
  69. Form and custom query problem
  70. Export Specific User data without plugin
  71. How to write: $wpdb->update having WHERE NOT value pair in the array
  72. Exclude all sticky posts front page twenty twelve
  73. wpdb COALESCE won’t work
  74. get csv of users with user_meta
  75. Query does not return content
  76. Parse query filter in wordpress and relation
  77. get posts by tag to showing in a widget
  78. Mysql query not working on WordPress 4.2.2
  79. List WordPress Post and Related Attachments outside of a post page
  80. How properly create a blog template for wordpress?
  81. Is there a way to add a link directly into this media query?
  82. Display latest post from WordPress Featured Category that is also in X,Y,or Z categories
  83. SQL query – get a featured image’s alt / alternative text
  84. Customising the default wordpress search functionality
  85. Question about of query
  86. Sort by postmeta on when searching
  87. Pulling an ACF into a query
  88. Using cron for multiple queries
  89. very slow wordpress query with default query
  90. Custom Query problem access the values
  91. Set posts per page for parent category and it’s all children
  92. Exclude sticky posts from query
  93. Rewrite Query_Var URL Parameter with Slug
  94. How to query different categories on index?
  95. Can’t See Media Queries with Inspect Tool [closed]
  96. Print data from wordpress sql query
  97. How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
  98. update $wpdb one query
  99. Admin Post List table Query filtering “WHERE” for custom post type
  100. How to use a dynamic term id for the query block