SELECT CONCAT(LEFT(`name`, 1), '. ', `lastname`) AS `short_name` FROM `clients` WHERE POSITION('tt' IN `lastname`) != 0 OR POSITION('ss' IN `lastname`) != 0 OR SELECT * FROM `clients` WHERE `phone` ...
This code is based off the xml-parser here: https://github.com/segmentio/xml-parser. Please see that page for details of the JSON output. The parse function takes an ...