sql查询以获取记录. [英] sql query to fetch the records..

问题描述

我有两列..


客户代码地址
A002 RAHIM APARTMNET，GULZAR LANE，汽油泵附近|海得拉巴| 500001 |安得拉|印度
A002 RAHIM APARTMNET，GULZAR LANE，汽油泵附近|孟买| 400001 |马哈拉施特拉邦|印度
C001 RAHIM APARTMNET，GULZAR LANE，汽油泵附近|班加罗尔| 400001 |卡纳塔克邦|印度
C002 RAHIM APARTMNET，GULZAR LANE，PETROL PUMP附近|浦那| 400001 |马哈拉施特拉邦|印度
D002 RAHIM APARTMNET，GULZAR LANE，汽油泵附近|阿南塔普(Anantapur)| 400001 |安得拉(Andhra)|印度
D002 RAHIM APARTMNET，GULZAR LANE，汽油泵附近| Chennai | 400001 | TamilNadu | INDIA

我想获取基于City的ClientCode....请帮助我...

I have two columns..


ClientCode Address
A002 RAHIM APARTMNET,GULZAR LANE,NEAR PETROL PUMP|Hyderabad|500001|Andhra|INDIA
A002 RAHIM APARTMNET,GULZAR LANE,NEAR PETROL PUMP|Mumbai|400001|Maharashtra|INDIA
C001 RAHIM APARTMNET,GULZAR LANE,NEAR PETROL PUMP|Bangalore|400001|karnataka|INDIA
C002 RAHIM APARTMNET,GULZAR LANE,NEAR PETROL PUMP|Pune|400001|Maharashtra|INDIA
D002 RAHIM APARTMNET,GULZAR LANE,NEAR PETROL PUMP|Anantapur|400001|Andhra|INDIA
D002 RAHIM APARTMNET,GULZAR LANE,NEAR PETROL PUMP|Chennai|400001|TamilNadu|INDIA

i want to fetch ClientCode based on City....please help me out...

推荐答案

您的查询将像这样....

your query will be like that....

select ClientCode from TableName where Address like 'here your search parameter'

e.g

select ClientCode from TableName where Address like 'Mumbai'

OR

select ClientCode from TableName where Address like '%here your search parameter'

OR

select ClientCode from TableName where Address like '%here your search parameter%'

您的表未正确定义.您必须将地址字段拆分为一些单独的文件，例如城市，邮政编码，省，道路等.

Your table is not correctly defined. You have to split the address field into some separate fileds, like city, post code, province, road, etc.

这篇关于sql查询以获取记录.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！