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 vote375 views2 answers
Procedure syntax
SQL
5 votes340 views4 answers
Sql check
SQL
3 votes367 views1 answer
Kill mysql processlist in whose time more than 200
SQL
21 votes351 views1 answer
Cheatsheet for sql
SQL
0 vote288 views1 answer
Import sql file in mysql linux
SQL
6 votes337 views2 answers
Mysql set primary key
SQL
1 vote355 views1 answer
Psql search table
SQL
0 vote376 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote364 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote324 views1 answer
Sql roll up rows into columns
SQL