By default mysql searches are case insensitive, that is from the following table:

cms
description
rating

Joomla
Joomla is an open source cms with nice design
3

Drupal
Drupal is an open source CMS framework based on MVC architecture
4

This query:
SELECT * FROM `table` WHERE `cms` LIKE ‘%JOOMLA%’
will fetch the first row of the records. If we want to case sensitive select, we can […]