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 vote122 views1 answer
Plsql find location of procedure
SQL
5 votes118 views2 answers
Oracle apex debug mode
SQL
4 votes126 views1 answer
SQL find text in SP
SQL
0 vote118 views1 answer
Exec procedure oracle
SQL
0 vote114 views1 answer
Mysql identified by syntax error
SQL
0 vote122 views1 answer
Mysql server not running
SQL
7 votes107 views3 answers
How ot change name of column mysql
SQL
0 vote105 views1 answer
Clone table structure mysql
SQL
92 votes313 views6 answers
Substring
SQL
0 vote118 views1 answer
Oracle sql date summer time
SQL