开发者

Search program in multiple table in php mysql

I have 2 tables. I have to search for strings from both tables. I am using getfulltext search query in MySQL. How do I search both tables. Both tables are unique and there there is not any reference id between them. My present table query is below :

1st tablename= Table_1
2nd tablename= Table_2

("SELECT *FROM Table_1 Where  MATCH(searchkey) AGAINST ('search_string' IN BOOLEAN MODE) ");
开发者_StackOverflow社区


You say your two tables have IDs? If these IDs aren't related to each other, or you have no other field in the two tables that you can use to reference each other, then you can't join them in a single query. Obviously your first table has more than ID and searchkey if you're looking for a location and city.. You need to provide more information about you're tables and what you're trying to do in order to get more help

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜