Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and works. Contact: aviboots(AT)netvision.net.il
BlueHost Web Hosting

Liquid Web Managed Dedicated Server: RAID 1 SSD with 16GB of RAM minimum! 24/7 On-Site Heroic Support! Industry-Leading SLA!

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

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

getflywheel wordpress hosting


Liquid Web Cloud VPS Hosting

9,383 questions

12,915 answers

573 users

How to match a whole word in MySQL with SQL

14 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
...