Question

Write an SQL query to print the first three characters

Answer 1

sǫʟ sᴇʀᴠᴇʀ sᴜʙsᴛʀɪɴɢ() ғᴜɴᴄᴛɪᴏɴ

• sǫʟ sᴇʀᴠᴇʀ sᴜʙsᴛʀɪɴɢ() ғᴜɴᴄᴛɪᴏɴᴇxᴛʀᴀᴄᴛ 3 ᴄʜᴀʀᴀᴄᴛᴇʀs ғʀᴏᴍ ᴀ sᴛʀɪɴɢ, sᴛᴀʀᴛɪɴɢ ɪɴ ᴘᴏsɪᴛɪᴏɴ 1: sᴇʟᴇᴄᴛ sᴜʙsᴛʀɪɴɢ('sǫʟ ᴛᴜᴛᴏʀɪᴀʟ', 1, 3) ᴀs ᴇxᴛʀᴀᴄᴛsᴛʀɪɴɢ;

• ᴇxᴛʀᴀᴄᴛ 5 ᴄʜᴀʀᴀᴄᴛᴇʀs ғʀᴏᴍ ᴛʜᴇ "ᴄᴜsᴛᴏᴍᴇʀɴᴀᴍᴇ" ᴄᴏʟᴜᴍɴ, sᴛᴀʀᴛɪɴɢ ɪɴ ᴘᴏsɪᴛɪᴏɴ 1: ...

• 1: ...ᴇxᴛʀᴀᴄᴛ 100 ᴄʜᴀʀᴀᴄᴛᴇʀs ғʀᴏᴍ ᴀ sᴛʀɪɴɢ, sᴛᴀʀᴛɪɴɢ ɪɴ ᴘᴏsɪᴛɪᴏɴ 1:

$▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄$