CODEWITHSUNDEEP
sqlsql-serversql-server-2008
user2881809
user2881809

Reputation:

how search word in sql?

Good day.

Code:

column name have rows:

about word test plus
about word tests plus
about word test plus
about word tests plus
about wordtest plus
about wordtests plus
about word testplus
about word testsplus
about wordtestplus
about wordtestsplus

i have sql query:

SELECT * FROM TABLE WHERE text LIKE 'test' OR text LIKE 'tests'

Tell me please, how select only rows when exist only full words test or tests?

P.S. in my example me need get rows:

about word test plus
about word tests plus
about word test plus
about word tests plus

Upvotes: 0

Views: 133

Answers (2)

Bogdan Bogdanov
Bogdan Bogdanov

Reputation: 1723

You need this query to receive desired result:

SELECT * FROM TABLE WHERE name LIKE '% test %' OR name LIKE '% tests %';

Upvotes: 3

Madhivanan
Madhivanan

Reputation: 13700

SELECT * FROM TABLE WHERE ' '+text+' ' LIKE '% test %' OR ' '+text+' ' LIKE '% tests %'

Upvotes: 3

Related Questions