SQL string does not work -> SQL LOWER

Question

Table page:

| id | page_title |

| 1 | John_Lennon |

Select:

SELECT * FROM page WHERE LOWER(page_title) = 'john_lennon';

I want to have the row with page_title = 'John_Lennon'. I don't know why, but it does not work. In phpmyadmin it returns null.

Try this, SELECT * FROM page WHERE page_title LIKE '%john_lennon%'; — Anonymous Duck, Jun 04 '15 at 18:06

score 1 · Answer 1 · answered Jun 04 '15 at 18:12

1

There could be extra spaces present in that column data and so it's not matching. Try using TRIM() function as well along with LOWER() like

SELECT * FROM page WHERE TRIM(LOWER(page_title)) = 'john_lennon';

answered Jun 04 '15 at 18:12

Rahul

It returns also null :/ – Name Jun 04 '15 at 18:25
1

Can you post you table schema/definition? looks like a problem with `collation` – Rahul Jun 04 '15 at 18:27
LOWER() might not do what you expect against a VARBINARY column, see: http://stackoverflow.com/questions/6807839/mysql-case-insensitive-search-on-varbinary-field – chsh Jun 04 '15 at 19:57

1 Answers1