你表达了2个不同的查询，它将是2个不同的表。（99%是Cassandra）。
您将不得不创建一个专用表来查找移动的。在查找表中，您可以将电子邮件作为聚类键来验证配对。

CREATE TABLE users_profile_by_email(
  email    TEXT,
  mobile   TEXT,
  username TEXT,
  PRIMARY KEY((email))
);

CREATE TABLE users_profile_check_mobile(
  mobile TEXT,
  email  TEXT,
  PRIMARY KEY((mobile), email)
);

插入2个用户（一个批处理语句的良好用法示例）

BEGIN BATCH
INSERT INTO users_profile_by_email(email, mobile, username) VALUES ('[email protected]', '111-111-1111', 'user1');
INSERT INTO users_profile_check_mobile(mobile, email) VALUES ('111-111-1111', '[email protected]');
APPLY BATCH;

BEGIN BATCH
INSERT INTO users_profile_by_email(email, mobile, username) VALUES ('[email protected]', '222-222-2222', 'user2');
INSERT INTO users_profile_check_mobile(mobile, email) VALUES ('222-222-2222', '[email protected]');
APPLY BATCH;

一个用户正在注册.

• 电子邮件是否已在使用中？*

select count(email) as email_count
from users_profile_by_email 
where email='[email protected]'

• 移动的是否已被使用？*

select count(mobile) as mobile_count
from users_profile_check_mobile 
where mobile='222-222-2222';

• 对email/mobile有效吗？*

select count(*) as mobile_count
from users_profile_check_mobile 
where mobile='222-222-2222' 
and email='[email protected]';