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 vote133 views1 answer
Sql drop with dependencies
SQL
0 vote124 views2 answers
Insert into
SQL
17 votes153 views4 answers
Mysql remove ubuntu
SQL
0 vote135 views1 answer
Mysql select inside sum
SQL
4 votes161 views1 answer
Alter session set nls_date_format
SQL
0 vote139 views1 answer
Neo4j command to run script file
SQL
6 votes141 views1 answer
T-sql test if table exists
SQL
1 vote129 views1 answer
Get table column names sql ssms
SQL
3 votes125 views1 answer
Search for column name in psql
SQL
0 vote140 views1 answer
How to tell if i have lactose intolerance
SQL