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 vote110 views1 answer
Sql find all different values in column
SQL
1 vote106 views1 answer
Oracle stop job
SQL
0 vote111 views4 answers
Postgresql between month
SQL
0 vote110 views1 answer
Oracle concat datetime
SQL
0 vote100 views2 answers
Sql join on wildcard
SQL
2 votes130 views1 answer
Python sql
SQL
0 vote123 views1 answer
Dual in db2
SQL
1 vote98 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote111 views1 answer
How to query all tables mysql at the same time
SQL
0 vote186 views1 answer
Oracle sql alter view add column
SQL