从表中提取值 [英] extracting values from a table

问题描述

我的表格中包含以下字段：personid，firstname，lastname。我正在尝试提取那些没有名字或姓氏的名字


所以如果我的表格的价值如


personid / firstname / lastname


1 Jim Lee

2 Erik

3史密斯


我希望查询返回＃2和＃3，因为＃2中缺少姓氏，＃3中缺少第一个名称。


任何帮助都是赞赏。


由于

解决方案

你有一个唯一的ID设置为您的表的0柱上？

您是否将唯一ID设置为表的0列？


我想知道怎么会有助于选择这些记录


罗纳德：冷静：

我想知道怎么会有助于选择这些记录


罗纳德：冷静：

我见过mysql选择不能正常工作......

Hi,

My table has following fields personid, firstname, lastname. I''m trying to extract those names that do not have either the firstname or the last name

so if my table has values like

personid/firstname/lastname

1 Jim Lee
2 Erik
3 Smith

I want the query to return # 2 and # 3 since the last name is missing in # 2 and the first name is missing in # 3.

Any help on this is appreciated.

Thanks

解决方案

Do you have a unique id set as the 0 column of your table?

Do you have a unique id set as the 0 column of your table?

I would like to know how that could help to select these records.

Ronald :cool:

I would like to know how that could help to select these records.

Ronald :cool:

I''ve seen mysql selects not work on less...

这篇关于从表中提取值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！