Query with multiple values in a column

by

The best solution would be to normalize your schema. You should have a separate table with one row for each child, instead of a comma-delimited list. Then you can join with this table to find parent with a specific child. See @themite’s answer for an example of this.

But if you can’t do that for some reason, you can use FIND_IN_SET:

WHERE FIND_IN_SET('Alex', children)

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  3. The requested URL was not found on this server.
  4. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  5. SQL injections in ADOdb and general website security
  6. Save PHP array to MySQL?
  7. PHP PDO prepared statement — MySQL LIKE query
  8. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  9. How can I use mysqli_fetch_array() twice?
  10. Best practice multi language website
  11. Executing multiple SQL queries in one statement with PHP
  12. mysql_num_rows() expects parameter 1 to be resource, boolean given in [duplicate]
  13. Easy way to export a SQL table without access to the server or phpMyADMIN
  14. How to know if MySQLnd is the active driver?
  15. using nulls in a mysqli prepared statement
  16. How can I count the numbers of rows that a MySQL query returned?
  17. MySQL: Add sequence column based on another field
  18. How to run the PHP script at scheduled time
  19. How to handle error for duplicate entries?
  20. How to handle PDO exceptions [duplicate]
  21. MySql PHP select count of distinct values from comma separated data (tags)
  22. mysql_insert_id() returns 0
  23. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  24. Change name of Laravel’s created_at and updated_at
  25. How do I get database column names in Laravel?
  26. PDO and MySQL Fulltext searches
  27. How to avoid “Using temporary” in many-to-many queries?
  28. Replacing \r\n with PHP
  29. How to check if a value already exists to avoid duplicates?
  30. How to use MySQL Found_Rows() in PHP?

Leave a Comment