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 %';

Mysql does sentence contain word

SELECT *
FROM myTable 
WHERE myColumn REGEXP '[[:<:]]myword[[:>:]]'

Similar codes

7 votes167 views2 answers
Execute mysql file
SQL
0 vote167 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote178 views1 answer
Mysql get first 2 characters of string
SQL
1 vote164 views2 answers
Sql server add time to date
SQL
0 vote167 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote175 views1 answer
Max mysql
SQL
0 vote232 views1 answer
Mysql loop through databases and execute query
SQL
0 vote180 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
1 vote245 views4 answers
Alter schema sql
SQL
3 votes161 views2 answers
Sql server current date without time
SQL