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 vote368 views1 answer
Netstat -tln mysql
SQL
3 votes327 views1 answer
Select nextval from sequence sql
SQL
0 vote359 views1 answer
Sql multiple into
SQL
4 votes325 views1 answer
Oracle select first 10 rows
SQL
2 votes312 views1 answer
Get first 3 letters name in sql
SQL
0 vote333 views1 answer
Exec procedure oracle
SQL
4 votes359 views1 answer
W3schools create table
SQL
1 vote344 views1 answer
Regular expression in sql server
SQL
2 votes346 views1 answer
Postgresql update sequence next value
SQL
0 vote336 views3 answers
Sql delete all except
SQL