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

3 votes149 views1 answer
V$session not found in oracle
SQL
0 vote162 views1 answer
Mysql aspas simples
SQL
0 vote140 views1 answer
Suse start MySQL
SQL
0 vote144 views1 answer
Calculate age in sql
SQL
0 vote145 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote149 views1 answer
Mysql local password denied
SQL
13 votes166 views2 answers
Sqlite rename table
SQL
6 votes148 views1 answer
Postgres get size of database
SQL
1 vote144 views1 answer
Give a column name to values generated from case statement in sql
SQL
1 vote161 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL