I’ve always solved this using lower:
SELECT * FROM trees WHERE LOWER( trees.title ) LIKE '%elm%'
More Related Contents:
- MySQL Like multiple values
- Mysql: Order by like?
- how to use a like with a join in sql?
- How do you force mysql LIKE to be case sensitive? [duplicate]
- MYSQL OR vs IN performance
- SELECTING with multiple WHERE conditions on same column
- ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- Cannot delete or update a parent row: a foreign key constraint fails
- Using union and order by clause in mysql
- Using an Alias in SQL Calculations
- Can a table field contain a hyphen?
- OUTPUT Clause in MySQL
- Search all columns of a table using a single where condition with single keyword in mysql
- Using ORDER BY and GROUP BY together
- Sorting by date & time in descending order?
- Case statement in MySQL
- MySQL Pivot Table Column Data as Rows
- updating columns with a sequence number mysql
- MySQL, Concatenate two columns
- MySQL: Inner join vs Where [duplicate]
- MySQL SELECT LIKE or REGEXP to match multiple words in one record
- Selecting from two tables with inner join and limit [duplicate]
- Why the order of evaluation for expressions involving user variables is undefined?
- How to select data where a field has a min value in MySQL?
- How to SELECT by MAX(date)?
- get a recursive parent list
- MySQL OPTIMIZE all tables?
- Strip last two characters of a column in MySQL
- is there a length limit to group_concat or another reason why it would not work on a text field