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 vote209 views1 answer
Function plsql
SQL
2 votes182 views1 answer
Oracle sql concatenate results into string
SQL
4 votes196 views1 answer
Oracle error line
SQL
34 votes236 views6 answers
Install mysql client ubuntu
SQL
0 vote187 views1 answer
Renombrar tabla mysql
SQL
2 votes261 views1 answer
Create mysql user on all hosts
SQL
0 vote217 views1 answer
Leftjoin in sql
SQL
0 vote187 views1 answer
Acual month sql
SQL
0 vote184 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
5 votes201 views1 answer
Sql integer to serial
SQL