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 vote211 views1 answer
Mysql query single row
SQL
0 vote249 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote222 views1 answer
Pgadmin check database
SQL
4 votes268 views2 answers
Installing sql on ubuntu
SQL
0 vote242 views3 answers
Mysql CAST(amount as float)
SQL
-1 vote211 views2 answers
Installing mysql on centos 7
SQL
0 vote231 views1 answer
Sql basic commands
SQL
0 vote208 views1 answer
Create a sql server database programmatically
SQL
1 vote201 views1 answer
Ef core 5.0 usesqlserver not found
SQL
3 votes191 views1 answer
Oracle revoke grant
SQL