PHP mysql search multiple tables using a keyword

by 
$query = "(SELECT content, title, 'msg' as type FROM messages WHERE content LIKE '%" . 
           $keyword . "%' OR title LIKE '%" . $keyword ."%') 
           UNION
           (SELECT content, title, 'topic' as type FROM topics WHERE content LIKE '%" . 
           $keyword . "%' OR title LIKE '%" . $keyword ."%') 
           UNION
           (SELECT content, title, 'comment' as type FROM comments WHERE content LIKE '%" . 
           $keyword . "%' OR title LIKE '%" . $keyword ."%')";

mysql_query($query);

So, you are getting result from all of the three tables, and you can identify which row came from which table by looking at its type value.

More Related Contents:

  1. Can’t find FULLTEXT index matching the column list (indexes is set)
  2. PDO and MySQL Fulltext searches
  3. php (fuzzy) search matching
  4. How to sort MYSQL fulltext search results by relevancy
  5. If number have inside number string [closed]
  6. recurring system my sql query [closed]
  7. Cannot modify header information [duplicate]
  8. Gather column name of a table from database [closed]
  9. inserting information and image in php and mysql
  10. CodeIgniter – foreach loop
  11. Project Links do not work on Wamp Server
  12. Using Jquery Ajax to retrieve data from Mysql
  13. Laravel migration: unique key is too long, even if specified
  14. Laravel Eloquent select all rows with max created_at
  15. PHP, MySQL error: Column count doesn’t match value count at row 1
  16. MySQL – count total number of rows in php
  17. Advantages Of MySQLi over MySQL [closed]
  18. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  19. PHP PDO vs normal mysql_connect
  20. Can I create a database using PDO in PHP?
  21. PHP PDO and MySQLi [duplicate]
  22. SQLSTATE[HY000] [2002] A connection attempt failed.. – When attempting to connect from Local to remote server
  23. How to store an array into mysql?
  24. MySQL Error “Too many connections”
  25. Error 1148 MySQL The used command is not allowed with this MySQL version
  26. Connect to remote MySQL server with SSL from PHP
  27. Using utf8mb4 with php and mysql
  28. How do I save PHP session data to a database instead of in the file system?
  29. MySQL, how to insert null dates
  30. Escaping SQL queries in Codeigniter

Leave a Comment