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 vote195 views1 answer
Query builder doctrien return sql
SQL
1 vote179 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote180 views1 answer
Sql server isnull function nor working count
SQL
0 vote189 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote194 views1 answer
Sqlite insert or update
SQL
0 vote186 views1 answer
Sql count more than 1
SQL
1 vote190 views1 answer
Sql server loop over query
SQL
9 votes182 views1 answer
No sql
SQL
6 votes175 views1 answer
How to count number of rows in sql
SQL
0 vote177 views1 answer
Adding primery key constraint to a column
SQL