考虑多列使用MySQL查找重复项(Find duplicates using MySQL considering multiple columns)
我需要根据相同的
first_name, last_name
组合或同一个birth_date
查找重复使用。 我可以轻松尝试的是:SELECT id, first_name, last_name FROM users where id IN (SELECT id from users GROUP BY email HAVING count(*) > 1) GROUP BY email, id;
上面只给出了重复的电子邮件详细信息,但我对基于
first_name, last_name
组合或同样的birth_date
处理其他条件感到困惑。是否可以在单个查询中实现它?
I need to find duplicate uses based on either same
first_name, last_name
combination OR samebirth_date
. What I could comfortably try was:SELECT id, first_name, last_name FROM users where id IN (SELECT id from users GROUP BY email HAVING count(*) > 1) GROUP BY email, id;
The above gives only duplicate email details, but I'm bit confused about handling other conditions based on
first_name, last_name
combination OR samebirth_date
as well.Is it possible to achieve it in a single query?
原文:https://stackoverflow.com/questions/41121121
最满意答案
这段代码不起作用:
'cat' => 48,43,49,46,47,44,51,50,42,
你将不得不使用数组
'cat' => array(48,43,49,46,47,44,51,50,42),
This piece of code won't work:
'cat' => 48,43,49,46,47,44,51,50,42,
You'll have to use an array
'cat' => array(48,43,49,46,47,44,51,50,42),
相关问答
更多-
只需获取parent-id的所有子类ID,并将它们全部放在一个简单的数组中。 然后使用in()进入具有distinct选择的查询。 请看下面的内容: public function get_all_posts_by_category(&$output, $category_id) { //Array of categories with parent category at top $cats = array(); $cats[] = $category_id; //Fet ...
-
我有类似的情况,无法找到答案: 检索属于custom_taxonomy1且属于custom_taxonomy2的相同custom_type的所有帖子。 示例:我需要属于某个政党(custom_taxonomy2)的SectorA(custom_taxonomy1)的所有提案: 我最终使用了以下适用于我的案例的查询,你可能会得到一个想法,并为你的想法: SELECT wposts.ID, wposts.post_title, wposts.post_type, wposts.post_status, ...
-
您最好的选择可能是运行SQL查询来一次设置所有帖子的类别。 global $wpdb; $category = get_category(get_query_var('category')); $term_taxonomy_id = $category->term_taxonomy_id; $wpdb->query(" INSERT INTO $wpdb->term_relationships ( object_id, term_taxonomy_id, term_order ) S ...
-
删除下面的代码。 这只适用于帖子。 $cat_args = array( 'orderby' => 'rand', 'order' => 'ASC' ); 使用代码如下: $categories = get_categories(); shuffle ($categories); // Just add shuffle and you will get random categories. Remove below code. This will only w ...
-
这个问题已经在wordpress.stackexchange上得到了答案。 所以在这里复制相同的代码 https://wordpress.stackexchange.com/questions/4201/how-to-query-posts-by-category-and-tag global $wp_query; $args = array( 'category__and' => 'category', 'tag__in' => 'post_tag', / ...
-
正如您在复制的代码中看到的那样, $category_names是一个数组。 您无法以此方式echo数组,以获得此输出:
-
您的代码有错误。 使用以下代码。 我希望这会正常工作。 'animal_category' ); $categories = get_categories($cat_args); foreach ( $categories as $category ) { $category_hero = get_field('hero', $taxonomy . '_' . $category->term_id); ?>首先你应该使用term_id ,而不是id ,然后你应该在tax_query中添加额外的array ,因为你不能有多个。 所以你的代码看起来像这样: $category_ids = array(1,2); $query->set( 'category__in', $category_ids ); After hours of debugging I finally found the solution... There was several mistakes as: Ids needs to be In ...
获取多个类别的帖子(Get posts multiple categories)[2021-11-25]
如Wordpress文档中所述,您似乎必须将类别作为数字传递,并且我没有在文档中看到'category_name'作为选项。 您似乎每次get_posts()调用只能传递一个类别。 所以对于一个类别: $posts = get_posts(array( 'posts_per_page' => -1, 'category' => '2' ) ); 或多个 $vars = array( array( 'posts_p ...相关文章
更多- mysql问题
- 关于netbeans和mysql的问题
- 关于mysql 的 sql
- mysql去除查询记录集重复的项目
- 关于mysql数据库memory表数据重复问题
- Setting up Nutch 2.1 with MySQL to handle UTF-8
- 通过Sqoop实现Mysql / Oracle 与HDFS / Hbase互导数据
- shell操作mysql初步
- MySQL用户与授权
- Mysql删除binlog(安全清理)
最新问答
更多- 您如何使用git diff文件,并将其应用于同一存储库的副本的本地分支?(How do you take a git diff file, and apply it to a local branch that is a copy of the same repository?)
- 将长浮点值剪切为2个小数点并复制到字符数组(Cut Long Float Value to 2 decimal points and copy to Character Array)
- OctoberCMS侧边栏不呈现(OctoberCMS Sidebar not rendering)
- 页面加载后对象是否有资格进行垃圾回收?(Are objects eligible for garbage collection after the page loads?)
- codeigniter中的语言不能按预期工作(language in codeigniter doesn' t work as expected)
- 在计算机拍照在哪里进入
- 使用cin.get()从c ++中的输入流中丢弃不需要的字符(Using cin.get() to discard unwanted characters from the input stream in c++)
- No for循环将在for循环中运行。(No for loop will run inside for loop. Testing for primes)
- 单页应用程序:页面重新加载(Single Page Application: page reload)
- 在循环中选择具有相似模式的列名称(Selecting Column Name With Similar Pattern in a Loop)
- System.StackOverflow错误(System.StackOverflow error)
- KnockoutJS未在嵌套模板上应用beforeRemove和afterAdd(KnockoutJS not applying beforeRemove and afterAdd on nested templates)
- 散列包括方法和/或嵌套属性(Hash include methods and/or nested attributes)
- android - 如何避免使用Samsung RFS文件系统延迟/冻结?(android - how to avoid lag/freezes with Samsung RFS filesystem?)
- TensorFlow:基于索引列表创建新张量(TensorFlow: Create a new tensor based on list of indices)
- 企业安全培训的各项内容
- 错误:RPC失败;(error: RPC failed; curl transfer closed with outstanding read data remaining)
- C#类名中允许哪些字符?(What characters are allowed in C# class name?)
- NumPy:将int64值存储在np.array中并使用dtype float64并将其转换回整数是否安全?(NumPy: Is it safe to store an int64 value in an np.array with dtype float64 and later convert it back to integer?)
- 注销后如何隐藏导航portlet?(How to hide navigation portlet after logout?)
- 将多个行和可变行移动到列(moving multiple and variable rows to columns)
- 提交表单时忽略基础href,而不使用Javascript(ignore base href when submitting form, without using Javascript)
- 对setOnInfoWindowClickListener的意图(Intent on setOnInfoWindowClickListener)
- Angular $资源不会改变方法(Angular $resource doesn't change method)
- 在Angular 5中不是一个函数(is not a function in Angular 5)
- 如何配置Composite C1以将.m和桌面作为同一站点提供服务(How to configure Composite C1 to serve .m and desktop as the same site)
- 不适用:悬停在悬停时:在元素之前[复制](Don't apply :hover when hovering on :before element [duplicate])
- 常见的python rpc和cli接口(Common python rpc and cli interface)
- Mysql DB单个字段匹配多个其他字段(Mysql DB single field matching to multiple other fields)
- 产品页面上的Magento Up出售对齐问题(Magento Up sell alignment issue on the products page)