
How to amatch whole word in SQL
Problem
How to match whole word in SQL.
We very frequently face the requirement to match an entire word, while developing the website/application.
Solution
This problem can be very easily handled by Microsoft SQL query.
For example when you search for “ram”, if you use “%ram%” it will also match “programme”.
To resolve this, we can use regular expression like syntax in SQL.
The below query will only return the title having “ram” and not “programme”.
select title from article where ‘ ‘+title like ‘%[ ]ram[ ]%’
Additionally we also can provide extra characters to match after word like
select title from article where ‘ ‘+title like ‘%[ -_]ram[ .-_]%’
Enjoy working with SQL.More
Categories
- Android App Development6
- App Store Optimization2
- Apple Watch App Development8
- Asp Dot Net Boilerplate1
- ASP Dot Net Development26
- Asp Dot Net Zero1
- CakePHP Development1
- CMS Development6
- Codeigniter Development2
- CPANEL4
- CRM development2
- CRM Development India1
- Cross Platform App Development6
- Dedicated Development Centre1
- Dot Net Development28
- Drupal Web Development2
- Ecommerce Development13
- Google Panda 4.21
- Internet Marketing SEO5
- iOS App Development9
- iPhone App Development11
- Joomla Development3
- Mobile Application Development30
- My SQL Server3
- News62
- Open Source Development10
- PHP Development25
- Search Engine Optimization33
- Search Engine Optimization Service India20
- SEO India21
- Sharepoint Development2
- Social Media Optimization2
- Software Development11
- Swift Programming Language1
- Technology11
- Uncategorized12
- Web Design and Development20
- WordPress Customization8
- WordPress Development11

WooCommerce vs Shopify – What’s Good For Your eCommerce Website Development in India?
