[SOLVED] MariaDB/MySQL not finding result in database

[DanishMale]

Hi all,

I try to execute this SQL via ZEOS:

Code: Pascal  [Select][+][-]

1. SELECT * FROM `tablename` WHERE LOWER(`column2`) LIKE LOWER('The%sample%is%made%by%me%');

Expected result from column1 would be 'Example'

However, I do NOT receive the expected result, even that column2 contains a recordset with 'The sample'

Database recordset looks like this

id   column1    column2
.....
23  Example    The sample
.....

[dseligo]

This has nothing to do with Zeos.
Where condition in your query expects words 'The', 'sample', 'is', 'made', 'by' 'me' in column2. If column2 would contain string 'The sample bla is bla made bla by bla me bla' then you'll get your row.
Or if you change your query to:

Code: SQL  [Select][+][-]

1. SELECT * FROM `tablename` WHERE LOWER(`column2`) LIKE LOWER('The%sample%');

[DanishMale]

Thanks  I was just hooked on an idea which according to your explanation won't work

And I found a "workaround"

Code: Pascal  [Select][+][-]

1. SELECT * FROM `tablename` WHERE LOWER(`column2`) LIKE LOWER(SUBSTR('The%sample%is%made%by%me%',1,LENGTH(`column2`)));