How to check if a value exists in one of two database tables

You had not very good architecture for your application. Best way is in save user information in one table and use separated fields or linked table for save extra information.

In your case you case use UNION and check tables in one query.

And correct way is use SELECT COUNT(*) and check result instead SELECT *

Related Posts:

  1. How to return number of found rows from SELECT query
  2. what is the use of /wp-includes/SimplePie?
  3. Inserting dynamic content into a page
  4. Check if post of title already exists
  5. How to export/import theme customizer settings?
  6. $wpdb->delete column values IN ARRAY()?
  7. Inserting choice in database table
  8. WP API V2 returning Invalid User ID
  9. How To Make Connection To WordPress Data Base In A Plugin?
  10. Has anyone tried putting PHP ActiveRecord on WordPress?
  11. How to auto login user again after change user_login
  12. WordPress admin never finishes saving page on site with large page count
  13. Retrieving and Displaying Data From a Table
  14. Duplicate domain database to local – How?
  15. How can I call a row of user specific data from a custom table added to the WP Database
  16. How to merge local and live databases?
  17. How to track a users progress through pages by inserting data into WordPress Database?
  18. WPDB: how to get the value of a field in a custom database table
  19. Notice: wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder
  20. Access/update database with jQuery
  21. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  22. #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  23. How to create and work with custom data / tables (i.e., for arbitrary data)?
  24. Add custom php database code above
  25. wp_insert_post not working
  26. Prevent Data Resubmission On Page refresh
  27. SQL QUERY – Select a value directly from the database
  28. Any possible way to make $wpdb->get_results() return anything else than array?
  29. Transferring working local PHP site to wordpress – with database (MySQL)
  30. Accessing the database from a plugin outside of action hooks
  31. Getting id of poll from WP database
  32. Storing Array from returned database query and using the array in a new query
  33. WordPress not reflecting changed of the database
  34. How to save checkbox values for logged in users?
  35. How does WordPress know wich language is chosen when there is a database connection error
  36. How can I save unique user data on my site? [closed]
  37. Dynamic content in template
  38. Using custom tables for old posts
  39. db converts decimal number wrong
  40. Not connecting to database in file with multiple MySQL connections
  41. How can I import an excel column into wordpress database?
  42. WordPress Block developer from exporting Database via PHP
  43. Execute a function every hour in the background
  44. Create page with custom php script and fetched data
  45. How do I display offsite database info on my wordpress site?
  46. Creating Database Table vs. Adding MetaData to Post & User
  47. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  48. Building a REST API for your web app exposes primary keys of DB records?
  49. Most commented posts by time period (last 12h, last 24h and etc)
  50. wpdb Cannot Update column in Database
  51. Cant connect to database with php 7.3
  52. Set default Database Storage Engine when creating tables with plugins?
  53. WPDB – Read and write value from / to database
  54. How do I make this Metabox show current DB value?
  55. How to Generate a list of Most Commented post?
  56. Why when I create a new post I found 2 record related to this post into the posts database table?
  57. SQL error with custom query
  58. Unserialize Custom Field & Save as Multiple Rows in WordPress Database
  59. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  60. Tracking Visitor LatLng with WordPress using JS, PHP. How to put data which was extract using JS into DB
  61. $_POST returning empty values
  62. How to send custom form submissions to WordPress Database?
  63. Submiting with problems on one of the options php wprdpress
  64. wp_update_post gives 500 internal error
  65. Confuse between forms and tables
  66. code that I can run, or a plug in to show what sql tables something pulls information from
  67. Adding column to wpex_users
  68. Using wpdb to connect to a different database is not working
  69. why not selecting multiple rows of same standard_id using SQL query from database?
  70. getting the values of hidden inputs to use them in a php mysql query
  71. custom search query database in child theme
  72. wp-login.php?redirect_to=https problem
  73. Insert data from form to database
  74. How to query a staging database?
  75. Get meta_query value by user meta array
  76. I changed the password for the database user of my website, updated wp-config.php and wordpress asks to be reinstalled
  77. I want to use wordpress database in android app using json encode?
  78. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  79. Can form entries from a WordPress form go to a database
  80. AJAX Not Working With WordPress Database properly
  81. Weird Behaviour: Not all WordPress Posts appearing
  82. Can not manually create a database ( db, user, pass ) for a plugin
  83. two wordpress sites, two themes, one database, same content
  84. Insert double entry in DB
  85. Manipulate database of WordPress site with my own scripts
  86. Problems with plugin that fetches data from database with ajax
  87. Check if values exists DB
  88. MySQL database migration to WordPress
  89. Host does not allow remote connection, so how do I transfer data to my WordPress site?
  90. MySQL Engine vs. Charset
  91. Custom query_posts() parameter
  92. How to pass username into form that sends data to database
  93. How to edit the default database of WordPress [closed]
  94. Insert into db with foreach problem
  95. notify users when changed database
  96. Execute multiple PHP Snippets causes error?
  97. Putting form result in my database
  98. Bulk data save in custom table
  99. WordPress Insert line in DB when clicking a button
  100. Updates applied to staging WordPress site affecting production even with different databases