问题描述
请参阅此页面这个问题的背景。
1.如果我写查询：
SELECT姓氏来自StaffRecord WHERE（Firstname ='Danny'AND Middlename ='James';
我会得到任何结果，考虑到Surname，Firstname和Middlename都存储了作为BLOB。
2.您会推荐以下哪些查询：
（a）SELECT姓氏来自StaffRecord WHERE（名字= 'Danny'AND Middlename ='James';
（b）SELECT姓氏来自StaffRecord WHERE（名字喜欢'Danny'和中间名喜欢'James';
考虑到Surname，Firstname和Middlename都存储为BLOB这一事实。
Please refer to this page for the background to this question.
1. if I write the query:
SELECT Surname FROM StaffRecord WHERE (Firstname = ' Danny ' AND Middlename = 'James';
will i get any result considering the fact that Surname, Firstname and Middlename are all stored as BLOB.
2. Which of the following queries is will you recommend:
(a)SELECT Surname FROM StaffRecord WHERE (Firstname = ' Danny ' AND Middlename = 'James';
(b) SELECT Surname FROM StaffRecord WHERE (Firstname LIKE ' Danny ' AND Middlename LIKE 'James';
considering the fact that Surname, Firstname and Middlename are all stored as BLOB.
推荐答案
这篇关于这种查询会起作用吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！