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

0 vote199 views1 answer
Import sql in postgresql
SQL
13 votes210 views4 answers
Command line mysql import
SQL
24 votes189 views4 answers
How to add column sql
SQL
13 votes192 views2 answers
Sqlite rename column
SQL
13 votes193 views4 answers
Mysql select last 10 rows
SQL
1 vote227 views1 answer
Insert many to many sql
SQL
0 vote198 views2 answers
Sql server select where date
SQL
0 vote193 views1 answer
Prepared statement mysql java delete selected rows
SQL
1 vote203 views1 answer
Wordpress change http to https phpmyadmin
SQL
17 votes217 views2 answers
Mysql date to string
SQL