Answers for "sql query contains like"

SQL
14

sql where contains

SELECT * FROM mytable
WHERE column1 LIKE '%word1%'
   OR column1 LIKE '%word2%'
   OR column1 LIKE '%word3%'
Posted by: Guest on January-22-2020
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
0

sql like %

SELECT * FROM Customers

 WHERE CustomerName LIKE '%a';
Posted by: Guest on June-01-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language