Answers for "sql contains vs like"

SQL
0

sql contains vs like

SELECT * FROM table WHERE Column LIKE '%test%';		-- can't use index
SELECT * FROM table WHERE CONTAINS(Column, 'test'); -- faster with full text index
Posted by: Guest on April-05-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language