I have a table for author names with two fields, first_name & last_name, both varchar(55), both nullable (for crazy business logic reasons) although in reality last_name is unlikely to ever be null.
My where clause for the search screen contains:
WHERE CONCAT(a.first_name, " " , a.last_name) LIKE "%twain%"
so that "Twain" or "Mark Twain" can be searched on. The table has about 15,000 rows & is expected to gradually grow, but won't ever be more than double that, and not for years.
I understand that there are many other parts of my query that will affect this, but given just that information, how might I best index this?
If it would make a great difference in performance, making last_name not nullable is an option, but not first_name