doupaxia2478 2013-03-19 08:51 采纳率: 100%
浏览 276
已采纳

在php mysql中查找具有相似名称的多个表

I'm trying to select data from two mysql tables using Join but I'm wanting to select from several tables with similar names such as profile_starter, profile_advanced, profile_premium, etc. My question is how can I select from the other tables without having to join more tables? I've tried * but it doesn't work:

    $inbox_sql = "
SELECT sender, recipient, time, message, viewed, name, avatar 
FROM messages 
LEFT JOIN profile_* ON profile_*.username = messages.sender
";

Please could you let me know if there's a solution to this? Thank you

  • 写回答

1条回答 默认 最新

  • dongpo9071 2013-03-19 08:58
    关注

    The answer to this is that you can't. When using JOIN the table name must be present in full, you cannot use wildcards.

    If the tables are the same how about looking at UNION and creating the dump of those tables in a sub query rather than joining each table to another query? - Might also be worth looking at a view, however these many not increase the performance, they would both need to be tested with your data and needs.

    It sounds like you only have 3 tables here, if you simplified this example you could query INFORMATION_SCHEMA TABLES with a wildcard to list out all the matching tables, then using this output build your query with the full table names in.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 微信购物商城购物车的所有功能以及购物车,和首页的搜索功能
  • ¥40 servlet的web程序部署出错
  • ¥50 activiti 新建流程系列问题
  • ¥50 为什么我版本升级之后运行速度变慢5倍??
  • ¥15 如何在gazebo中加载机械臂和机械手
  • ¥15 纯运放实现隔离采样方案设计
  • ¥20 easyconnect无法连接后缀带.com的网站,一直显示找不到服务器ip地址,但是带有数字的网站又是可以连接上的,如何解决
  • ¥15 电脑开机过商标后就直接这样,求解各位
  • ¥15 mysql , 用自己创建的本地主机和用户名 登录不上
  • ¥15 关于#web项目#的问题,请各位专家解答!