如何比较“From”数字

Question

我想比较数据库中的两个Twilio数字。因为它们以“+”开头，我不知道如何比较它们。这是我的代码来收集和保存数字到数据库。我正试着对照数据库检查输入的号码。你知道吗

if request.method == 'POST':
    a = Number.objects.all()
    from_number = request.POST.get('From', None)
    u = Number(cell_number=from_number)
    u.save()
    msg_new = 'We recorded your number as %s' % (from_number)
    m = Response()
    m.message(msg_new)
    return m

一如既往，谢谢你的帮助！你知道吗

更新

根据我收到的答案，我更新了密码。真管用！你知道吗

 if request.method == 'POST':
        from_number = request.POST.get('From', None)
        if Number.objects.filter(cell_number=from_number).exists():
            msg = "We already have your number recorded in our system."
            r = Response()
            r.message(msg)
            return r
        else:
            u = Number(cell_number=from_number)
            u.save()
            msg_new = 'We recorded your number as %s' % (from_number)
            m = Response()
            m.message(msg_new)
            return m

Answer 1

我假设您所引用的Twilio数字是以标准的E.164格式存储的，标准化的格式可以删除所有空格等

如果是这样，那么你所需要做的就是在数据库中查找数字。因此，要查看某个号码是否已经存在，您可以执行以下操作：

if Number.objects.filter(cell_number='+4412349834024').exists():
    # The number already exists in the database
else:
    # The number doesn't exist in the database, go ahead and add it

如果要以这种方式查询cell_number字段，可能需要确保它已被索引。你知道吗