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 vote274 views1 answer
How to get table current identity value in sql server
SQL
0 vote390 views1 answer
ORA-01400
SQL
4 votes284 views4 answers
Print pl sql
SQL
5 votes266 views3 answers
Mysql check if null or empty string
SQL
15 votes513 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote279 views1 answer
Sql insert from excel
SQL
0 vote298 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote297 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote301 views1 answer
Postgres can integer fields be negative
SQL
6 votes259 views1 answer
Sqlite foreign key
SQL