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 vote266 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote263 views1 answer
Select last 2 characters sql
SQL
1 vote279 views2 answers
Mysql between
SQL
0 vote270 views1 answer
Mssql now diff 90 day
SQL
0 vote280 views1 answer
Exectuer myssql .sql
SQL
0 vote267 views2 answers
Starting mysql service from mac
SQL
0 vote338 views1 answer
How to subquey to do not load in live database in
SQL
0 vote275 views1 answer
How to execute stored output to csv files
SQL
4 votes261 views1 answer
Mysql set max connections
SQL
0 vote274 views1 answer
Regex any word except sql
SQL