The danish language have three special characters, Æ, Ø, Å - æ, ø, å
These characters are also written as Æ = AE, Ø=OE, Å=AA, æ=ae, ø=oe, å=aa
For example is the name of one city in Denmark be spelled like this: Aalborg and like this: Ålborg.
My question is if ii is possible to create a SQL search in a way that when searching for Ålborg it will return Ålborg as well as Aalborg.
In this searchstring it returns nothing when searching Aalborg because in the database only the spelling Ålborg is used.
$query = $mysqli->prepare("SELECT * FROM ft WHERE Aar = ? AND AmtHerredSognGade LIKE '%".$sogn."%'");