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

28 votes357 views4 answers
Show tables mysql
SQL
1 vote380 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
3 votes360 views2 answers
Sql paging query
SQL
6 votes360 views2 answers
Oracle
SQL
0 vote401 views2 answers
Connect to mysql server mac terminal
SQL
0 vote423 views1 answer
Mysql delete entire row on condition
SQL
0 vote328 views1 answer
Declaring variables in pl sql
SQL
0 vote369 views1 answer
Connexion mysql
SQL
11 votes357 views2 answers
Turn off safe mode mysql
SQL
0 vote391 views2 answers
Select last 30 days sql
SQL