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 vote206 views1 answer
How to change mysql port in xampp
SQL
0 vote194 views1 answer
Oracle get running queries
SQL
0 vote207 views1 answer
Firebird where
SQL
0 vote216 views1 answer
Mariadb cast to int
SQL
1 vote227 views1 answer
Vagrant mysql downgrade version
SQL
3 votes194 views1 answer
Oracle apex message quit website
SQL
0 vote207 views1 answer
Mysql terminal list table
SQL
1 vote219 views2 answers
Get table column names sql laravel
SQL
6 votes203 views1 answer
Wordpress change user password sql
SQL
3 votes212 views4 answers
Stop MySQL
SQL