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

2 votes139 views3 answers
Sql server reseed identity column
SQL
0 vote143 views1 answer
Dual in db2
SQL
5 votes117 views1 answer
Sysdate in oracle sql
SQL
6 votes130 views1 answer
How to count number of rows in sql
SQL
0 vote140 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote115 views2 answers
Mysql regexp match word
SQL
1 vote115 views1 answer
Stop mysql server mac
SQL
0 vote142 views1 answer
Sql insert from excel
SQL
1 vote145 views1 answer
Add sequence postgres
SQL
0 vote170 views1 answer
Mysql faster delete
SQL