mysql does sentence contain word

Solutions on MaxInterview for mysql does sentence contain word by the best coders in the world

showing results for - "mysql does sentence contain word"
Nico
29 Nov 2020
1#select rows where myColumn has the actualy word (not just the string)
2#ie: the word has a space on one side of it
3SELECT * FROM myTable WHERE myColumn  
4like 'myWord' 
5or myColumn like  'myWord %'
6or myColumn like '% myWord'
7or myColumn like '% myWord %';
Paisley
26 Feb 2020
1SELECT *
2FROM myTable 
3WHERE myColumn REGEXP '[[:<:]]myword[[:>:]]'