> The db is already created.
All new dbs have errors. When found, they need to be corrected.
(For a basic intro on database design see
https://www.artfulsoftware.com/dbdesignbasics.html.)
> The table has a column with names
> (first and last nane in the same column,
> sometimes first name leads, sometimes follows
> last name. wrong or right?
Wrong, breaks atomicity---an elementary normalisation error.
> They asked me to find a way to do search in these columns.
If they don't know normalisation, they've no business designing databases.
> You mentioned to create a table with the triples.
It's a just a wee test/demonstration table for values that are case-insensitively equal but case-sensitively unequal. Its only purpose is to find whether your problem is specific to the db or table you referenced, or in in your server
> I can't make it. I do not have the data to create it.
Eh? Creating it needs no data. Populating it needs just the wee script I posted.
> They only said they succeeded without table like yours.
Meaningless---it's just just a temporary diagnostic device. It's not designed to accept your data.
Again, let's see the result of running my script on your server. Use the mysql client program.
Edited 1 time(s). Last edit at 12/01/2019 02:35PM by Peter Brawley.