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

7 votes148 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote221 views1 answer
Placements hackerrank solution
SQL
6 votes141 views6 answers
Count mysql
SQL
0 vote157 views1 answer
Ubuntu stop mysql from starting on boot
SQL
1 vote160 views1 answer
Delete specific row in sql
SQL
1 vote141 views1 answer
Group_concat max length mysql
SQL
5 votes167 views1 answer
Purge undo tablespace usage
SQL
0 vote175 views1 answer
How to get table id sequence postgres
SQL
10 votes139 views1 answer
Dba_dependencies
SQL
18 votes139 views3 answers
Mysql add column with default value
SQL