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

22 votes143 views4 answers
Mysql format date
SQL
0 vote116 views1 answer
Mysql 1 hour ago
SQL
3 votes116 views4 answers
Mysql create table from select statement
SQL
0 vote119 views1 answer
Write sql query to show the details start from digit
SQL
0 vote107 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote195 views1 answer
Multiple row join
SQL
0 vote126 views1 answer
Kill mysqld_safe process mariadb
SQL
1 vote108 views1 answer
Drop table if exists oracle
SQL
4 votes232 views6 answers
Laravel jwt
SQL
0 vote109 views1 answer
Sql server update top n records
SQL