Yes, DataTables sends the search request on each key-up in the "Search:" field.
"LIKE 'glyn%' will not work when searching for "glyn bartlett".
I have now tried the multiple OR statements (one for each column) with searchValue = searchValue.replace(" ", "%");. However, that works until "glyn " and then stops at "glyn b". This also needs to work if someone enters "bartlett glyn". These all work on the client-side version where the search is handled by DataTables. The issue is that I need to be able to replicate how DataTables does that search with my java code and/or MySQL.
I am concatenating my stored procedure depending on the values received. The two ways I have tried are:
This works on "g", "gl", "gly", "glyn", "glyn " and stops working on "glyn b".
This does not work until "glyn" is entered.
Note: I need the OR MATCH in the second code because "sd_start_date" is in a different table.