php - How to get all records without and with special (polish) charactersGet the solution ↓↓↓
Here's my current query:
SELECT * FROM example WHERE name LIKE '$myName%'
I have a lot of different rows in my database, and I want this query to get all rows with name starting with "myName". It works fine with this code, but it doesn't return rows with Polish chars.
I know about "COLLATE utf8_polish_ci" but I want to scrap also similar words, like in this example:
$myName = 'sc';
I want to scrape names like:
but ALSO names with polish similar chars, like
(where "s" could be "ś" and "c" could be "ć").
It was a bit hard to explain for me, I hope you understood this and can help me with better solution than making "OR" for each specific query.
People are also looking for solutions of the problem: port 80 in use by "unable to open process" with pid 4!
Didn't find the answer?
Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.
Find the answer in similar questions on our website.
Write quick answer
Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.