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

2 votes114 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote100 views4 answers
Mysql on kubernetes
SQL
5 votes136 views4 answers
Sql check
SQL
0 vote113 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
15 votes96 views7 answers
MYSQL
SQL
7 votes103 views1 answer
Mysql iif
SQL
0 vote99 views1 answer
Power bi dax add related shows column but not working
SQL
104 votes271 views2 answers
Like in mysql
SQL
15 votes109 views5 answers
Select all tables sql
SQL
1 vote105 views1 answer
What is a Database?
SQL