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 vote231 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
0 vote181 views1 answer
Oracle swap partition
SQL
0 vote214 views2 answers
Sql unique
SQL
0 vote174 views1 answer
Power bi find all ids not in other tables
SQL
5 votes170 views1 answer
Ascending order and where in sql
SQL
19 votes170 views6 answers
Sql create table
SQL
0 vote174 views1 answer
Mysql readable output
SQL
9 votes191 views6 answers
Check constraint in sql
SQL
1 vote181 views1 answer
Print year of a date sql
SQL
0 vote187 views1 answer
Oracle lower in where clause
SQL