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 vote197 views1 answer
How do you insert boolean to postgresql
SQL
2 votes140 views1 answer
Compare date in sql
SQL
7 votes151 views2 answers
N highest salary in sql
SQL
0 vote139 views1 answer
Sql recherche nom prenom
SQL
4 votes152 views1 answer
Sql quote in string
SQL
3 votes140 views1 answer
Mysql set field unique
SQL
0 vote140 views1 answer
Denormalise SQL command
SQL
0 vote135 views1 answer
RowDataPacket
SQL
15 votes144 views6 answers
Psql
SQL
1 vote148 views1 answer
How to copy data of a table from another database to table of anaother database
SQL