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 vote217 views1 answer
ORA-00942
SQL
3 votes121 views1 answer
Postgresql if null then 0
SQL
34 votes165 views6 answers
Alter table add foreign key mysql
SQL
0 vote140 views1 answer
EnvironmentError: mysql_config not found
SQL
-1 vote126 views5 answers
Online sql to linq generator
SQL
3 votes164 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
22 votes115 views2 answers
Mysql show all tables
SQL
0 vote133 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote120 views2 answers
Mysql regexp match word
SQL
3 votes168 views3 answers
List columns in table postgres
SQL