Search with comma-separated value mysql

by

Example of doing a join based on FIND_IN_SET

SELECT *
FROM imap_emails
INNER JOIN customers
ON FIND_IN_SET(customers.email, imap_emails.to) > 0

You don’t say how you want to narrow this down (ie, if an email uses 2 email addresses do you want both emails brought back), so can’t add much at this stage.

More Related Contents:

  1. Trying to Show 87 mysql rows in 3 html tables using PHP and mysql [closed]
  2. While loop inserts three times
  3. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in? [duplicate]
  4. regarding installation of php in windows
  5. Search engine PHP return error [closed]
  6. Auto Increment ID’s of 4 digit
  7. php nested while loop. Inner loop works only once [closed]
  8. Problame with files on SQL
  9. How to include a PHP variable inside a MySQL statement
  10. PDOException “could not find driver”
  11. Row count with PDO
  12. How do you connect to multiple MySQL databases on a single webpage?
  13. Best way to INSERT many values in mysqli?
  14. LIMIT keyword on MySQL with prepared statement [duplicate]
  15. Is mysql_real_escape_string() broken?
  16. How to setup ElasticSearch index structure with multiple entity bindings
  17. Export MySQL database using PHP [closed]
  18. How to add new column to MYSQL table?
  19. WAMP/MySQL errors not in correct language
  20. Get Updated Value in MySQL instead of affected rows
  21. Category Hierarchy (PHP/MySQL)
  22. Alternative for mysql_num_rows using PDO
  23. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  24. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given [duplicate]
  25. Select mySQL based only on month and year
  26. Mysql InnoDB engine in Laravel
  27. MySQL: Group by two columns and sum
  28. SQLSTATE[HY000] [1698] Access denied for user ‘root’@’localhost’
  29. Which MySQL datatype to use for an IP address? [duplicate]
  30. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

Leave a Comment