Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and works. Contact: aviboots(AT)netvision.net.il
Bonsai Boy of New York Bonsai Trees and Accessories

BlueHost Web Hosting

Liquid Web iThemes WordPress Hosting

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

DreamHost Web Hosting


Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

Liquid Web Cloud VPS Hosting

10,580 questions

14,379 answers

573 users

How to match a whole word in MySQL with SQL

Winter Travel Deals
16 views
asked Sep 11, 2018 by avibootz
edited Sep 12, 2018 by avibootz

1 Answer

0 votes
SELECT * 
FROM test 
WHERE keyword REGEXP '[[:<:]]web[[:>:]]'

-- run:

-- id 	keyword
-- 5 	web hosting services secure
-- 6 	web hosting secure
-- 7 	web hosting secure services
-- 10 	web hosting
-- 12 	web services
-- 14 	web services secure 
-- ....



answered Sep 11, 2018 by avibootz
edited Sep 12, 2018 by avibootz
...