All Questions
Tagged with contains sql-server
98
questions
0
votes
2
answers
61
views
SQL Contains Query Returning Different Results
I have a simple query
SELECT *
FROM QTests
WHERE CONTAINS(QTestId, '18 ~ 14 ~ 10')
Each time I run it it returns more results.
0
votes
1
answer
752
views
Use value from STRING_SPLIT function inside CONTAINS
I am trying to create SQL query (via full-text search) which will return along with CONTAINS multiple terms over multiple columns.
Below what I managed to create:
SELECT * FROM table
WHERE EXISTS (
...
1
vote
1
answer
355
views
SQL Server Full-Text Search Issue: Inconsistent Results Between CONTAINS and LIKE Queries with word 'za'
For the first time, I'm using full-text search. I have SQL Server 2022 Standard installed, and I've set up full-text search. I created a full-text catalog, [fullTextCatalog_CjeniciArtikli], with ...
0
votes
0
answers
43
views
fulltext index (CONTAINS) does not return all results and always cuts
Among more than 100 million text (abstracts of publications) indexed in my db (microsoft sql) table, I want to fetch all those abstracts containing the phrase 'machine learning'. To do so, I have ...
0
votes
1
answer
72
views
Sql Server CONTAINS function not works with some urls data
In my Sql Server database, I've a table containing an nvarchar(4000) field called DataStructure.
In this table I've 2 records having following data into DataStructure field:
Record 1:
{"FileName&...
0
votes
0
answers
42
views
Full text search, contains and correlated query [duplicate]
The rules table stores complex terms for FTS (e.g. '"endwith" and "startwith" or (...)')
The documents table stores contents of user's documents
Create a view to display all ...
0
votes
0
answers
53
views
SQL Server : Freetext search with And Operator
Project table Name columns contains this data:
USA Russia England Canada
Canada
Query:
SELECT name
FROM project
WHERE FREETEXT(name, '"USA Canada"')
Result: the query returns both rows.
...
-2
votes
1
answer
108
views
How can i use MsSQL Where CONTAINS inside a php query with double quotes?
I'm trying to create a SQL query in PHP where I'm searching through the columns for search results containing a specific string with a wildcard. I'm using CONTAINS for that and I've enabled Full Text-...
0
votes
1
answer
75
views
the contains prefix_term "06*" or simple term"06"returns a value where no word start with "06"
I am using contains command of SQL Server to search a column named text(nvarchar(max)), the query returns a row where the text value having no word starting with "06", while it does have the ...
0
votes
1
answer
93
views
SQL Server Differences? With Contains
I can run this (its a function generated query string from an online advanced search where user can add address, city, zip among other things...):
SELECT *
FROM MYTABLE
WHERE
FREETEXT(pCity, '...
-1
votes
3
answers
45
views
Displaying if clause finds results or not from SQL
I have the following example data in tableexample (im using MSSQL):
ID
date
tag
15551
2021-11-10
1
15551
2021-11-09
0
15551
2021-11-10
1
12123
2021-11-09
1
12123
2021-11-09
1
15551
2021-11-10
1
...
0
votes
0
answers
124
views
when i write MS SQL full text search query for return all matches, then it give me not correct output
this is my query:-
select * from dbo.zones where freetext(name, 'test');
select * from dbo.zones where contains(name, 'formsof(INFLECTIONAL, test)');
this give me result of- test, testing, tested
...
1
vote
1
answer
55
views
BRAVO value won't be found after a SQL SELECT CONTAINS
I have a very strange behavior on sql server.
I have a User table with one row having BRAVO as last name.
When I use this simple request:
select * from User u where contains (u.LastName, 'BRAVO')
it ...
0
votes
2
answers
288
views
SQL CONTAINSTABLE - Unexpected results
I have a table programs with some records and have a different results if using LIKE or CONTAINSTABLE.
CREATE TABLE Programs (
ID varchar(255) NOT NULL PRIMARY KEY,
Title varchar(255) NOT NULL
...
0
votes
0
answers
79
views
SQL Contains with optional search value
I've been using the CONTAINS function and have noticed some poor query times in a particular scenario.
Cut back version for simplicity:
SELECT *
FROM tablename
WHERE
(
@Keywords = '""'
OR
...