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

4 votes171 views3 answers
Sql find second highest salary employee
SQL
0 vote182 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
1 vote231 views2 answers
List tables sqlalchemy
SQL
6 votes191 views2 answers
Sql sequence
SQL
0 vote185 views1 answer
Postgresql auto increment not working
SQL
0 vote177 views1 answer
Oarcale list objects
SQL
44 votes301 views4 answers
Mysql alter table add column first
SQL
2 votes172 views1 answer
Sql server conection string
SQL
1 vote180 views1 answer
How to run sql script
SQL
0 vote214 views1 answer
Group by max date
SQL