MYSQL Select from tables based on multiple rows

by

You need to join with user_meta once for each attribute you want to match.

SELECT u.*
FROM users AS u
JOIN user_meta AS m1 ON u.id = m1.userID
JOIN user_meta AS m2 ON u.id = m2.userID
WHERE m1.meta_key = 'companyID' AND m1.meta_value = :companyID
AND m2.meta_key = 'user_type' AND m2.meta_value="staff"

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  2. Using PHP data in MySQL [closed]
  3. Checking the availability of rooms
  4. How to properly set up a PDO connection
  5. Commands out of sync; you can’t run this command now
  6. SELECT COUNT(*) AS count – How to use this count
  7. Get table column names in MySQL?
  8. How to resolve ambiguous column names when retrieving results?
  9. Loading .sql files from within PHP
  10. selecting unique values from a column
  11. Use bound parameter multiple times
  12. MySQL “NOT IN” query 3 tables
  13. Create a dynamic mysql query using php variables
  14. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  15. PHP: multiple SQL queries in one mysql_query statement
  16. How to separate DATE and TIME from DATETIME in MySQL?
  17. Why does this return Resource id #2? [duplicate]
  18. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  19. How to generate unique id in MySQL?
  20. Simple PHP SQL login troubleshooting
  21. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  22. MySql PHP select count of distinct values from comma separated data (tags)
  23. How to SELECT DEFAULT value of a field
  24. Laravel Eloquent get results grouped by days
  25. Do I have to use mysql_real_escape_string if I bind parameters?
  26. SELECT row by DATEPART()
  27. UNION syntax in Cakephp
  28. How do i search from serialize field in mysql database?
  29. PDO and MySQL ‘between’
  30. MySQL Join Multiple Rows as Columns

Leave a Comment