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 vote319 views1 answer
Python sqlalchemy connection show server
SQL
0 vote308 views1 answer
Mysql value ends with
SQL
-1 vote270 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote289 views1 answer
Using distinct and count together in sql
SQL
1 vote291 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote292 views1 answer
Sql select random procentage from rows
SQL
0 vote298 views4 answers
Postgresql between month
SQL
5 votes287 views3 answers
Mysql extract month from date
SQL
21 votes286 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote267 views1 answer
How many columns can be used for creating index?
SQL