I am building a multilingual web application.
Urls stored in database like:
id_url bigint(18)
id_map int(11)
id_entity bigint(18)
active tinyint(1)
lang varchar(8)
path varchar(500)
path_ids varchar(50)
full_path_ids varchar(50)
created_at datetime
My question is about path
indexing. I need to make search only LIKE '$str%
. I don't need LIKE '%$str'
.
Index is : idx_url_path BTREE No No path (255) 22 A No
It automatically degraded to 255
.
Any idea on how to get things done?