sql compare strings

VasteMonde answered on April 6, 2021 Popularity 10/10 Helpfulness 4/10

answer sql compare strings

sql compare strings

Comment

SELECT * FROM table WHERE Column = 'test';			-- can use index
SELECT * FROM table WHERE Column LIKE '%test%';		-- can't use index
SELECT * FROM table WHERE CONTAINS(Column, 'test'); -- faster with full text index

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: compare sql

Link to this answer
Share Copy Link

Contributed on Apr 06 2021

VasteMonde

0 Answers Avg Quality 2/10

sql compare strings

Contents

More Related Answers

sql compare strings

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.