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 vote256 views1 answer
How to fetch data from database in sql
SQL
0 vote226 views2 answers
Postgres another version
SQL
0 vote205 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
0 vote254 views1 answer
Array aggre distinct postgres
SQL
-3 votes301 views8 answers
Sql to c# linq converter online
SQL
0 vote214 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote226 views1 answer
Postgresql remove new line from string
SQL
0 vote227 views1 answer
Redudancy in SQL
SQL
0 vote246 views1 answer
SQL Cut part string
SQL
8 votes244 views3 answers
Connect python to mysql
SQL