So I have users with a
field_first_name and a
field_last_name and I need my query condition to be something like:
"field_first_name + ' ' + field_last_name LIKE :q".
Currently I have:
->condition(db_or()->condition('fn.field_first_name_value', $q, 'like')->condition('ln.field_last_name_value', $q, 'like'))
so if first name is "John" and last name is "Smith" and I search for "John S" I get nothing because it doesnt match the first OR last name, I need to check if it matches the firstname + the last name.
How do I do this in Drupal 7?