Answers for "mysql does sentence contain word"

SQL
1

mysql does sentence contain word

#select rows where myColumn has the actualy word (not just the string)
#ie: the word has a space on one side of it
SELECT * FROM myTable WHERE myColumn  
like 'myWord' 
or myColumn like  'myWord %'
or myColumn like '% myWord'
or myColumn like '% myWord %';
Posted by: Guest on May-19-2020
1

mysql does sentence contain word

SELECT *
FROM myTable 
WHERE myColumn REGEXP '[[:<:]]myword[[:>:]]'
Posted by: Guest on May-19-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language