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

2 votes342 views1 answer
Install postgresql centos 5
SQL
1 vote276 views1 answer
Sql myisam vs innodb
SQL
2 votes283 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote282 views1 answer
How to check default value of column in sql server
SQL
1 vote306 views1 answer
Sql select all from one table and one column from another
SQL
0 vote389 views1 answer
Play framework connection via windows sql server
SQL
4 votes290 views2 answers
Insert current date in mysql
SQL
0 vote306 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote306 views1 answer
Sql shell psql cannot enter password
SQL
0 vote287 views1 answer
How to check even or odd in sql
SQL