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 vote162 views1 answer
Postgresql linux password
SQL
2 votes178 views2 answers
Convert_tz mysql
SQL
1 vote215 views1 answer
Size of all tables in a schema oracle
SQL
3 votes200 views1 answer
Oracle function
SQL
0 vote161 views1 answer
Mysql insert into select with recursive
SQL
0 vote170 views1 answer
Load data infile mariadb slow
SQL
2 votes171 views1 answer
Install postgresql centos 5
SQL
22 votes261 views4 answers
Tsql rename table
SQL
0 vote173 views2 answers
Call to undefined function mysql_query()
SQL
4 votes149 views1 answer
Mysql timestamp in laravel migration
SQL