SQL help! - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

SQL help!

SQL help!# Database - 数据库

t*t2005-08-11 07:08

1 楼

How to check string A is a substring of string B in SQL? Specifiaclly, how to
finish the following SQL query:
select ...
from tableA x
where x.attributeA is a substing of stringB
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Thanks in advance!

p*k2005-08-11 07:08

2 楼

it depends on which Database server you are using.
you may find some string related function
look for examples or google.
for example:
USE Northwind
GO
SELECT ProductName
FROM Products
WHERE CONTAINS(ProductName, ' "sasquatch ale" OR "steeleye stout" ')
GO

to

【在 t******t 的大作中提到】

: How to check string A is a substring of string B in SQL? Specifiaclly, how to
: finish the following SQL query:
: select ...
: from tableA x
: where x.attributeA is a substing of stringB
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: Thanks in advance!

t*t2005-08-11 07:08

3 楼

I'm using Oracle 9.

【在 p*******k 的大作中提到】

: it depends on which Database server you are using.
: you may find some string related function
: look for examples or google.
: for example:
: USE Northwind
: GO
: SELECT ProductName
: FROM Products
: WHERE CONTAINS(ProductName, ' "sasquatch ale" OR "steeleye stout" ')
: GO