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

1 vote316 views3 answers
Psql fatal database does not exist
SQL
0 vote356 views3 answers
Select top 10 rows in sql
SQL
1 vote311 views1 answer
Sql select where id not exists in another table
SQL
-1 vote294 views2 answers
How to display top 50 rows?
SQL
0 vote319 views1 answer
Default value false mysql
SQL
0 vote321 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote267 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote351 views2 answers
Compound operator in sql
SQL
1 vote327 views1 answer
Mysql tables max count
SQL
0 vote352 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL